Skip to Content
0
Former Member
Jul 17, 2006 at 12:09 PM

Save a macro in a workbook

467 Views

Hello !!

I've got some questions with BEX !!

I created a workbook Etat_BW which contains a quiery.

This workbook is refreshed everyday (with manual opening of this workbook).

Each time I open a new connexion with BEX, and when i open Etat_BW, this workbook appears in a new file Excel.

I created too a macro "SendMail" which sends a part of an excelsheet to some people in a mail.

But this macro is applied for a File given (for example etat.xls, whereas each opening of Etat_BW launches a new file Excel "xsaTemp7990.xls" and the workbook is contained in this new file, so the macro is applied to etat.xls and not to my workbook Etat_BW)

So I've got two problems :

- The first one is to "save the macro in a workbook" in order that this macro can be used by people using/reading the workbook Etat_BW.

- The last one is how can I do to apply this macro for any excelsheet.

Thanks for your help !!

Vince.