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.