Macro1 runs Macro2


Posted by amroo on June 27, 2001 7:31 AM

Salut,
I have a Macro1 in WKB1.xls for importation file and Macro2 in WKB2.xls for operations on the file.
When I run Macro1 at the end I open WKB2 and want to run Macro2. I've read some code but no one work.
expl in Macro1 :
Application.Run WKB2.xls &"!"& Macro2 or
Run("WKB2.xls!Modul2") Macro2 is in Modul2.
Help is greatful(dead) appreciate.
A+mroo



Posted by Amroo on June 28, 2001 4:16 AM


Pas la peine de se casser la tête j'ai trouvé tout seul.