Hi Sylvain,

Try:

Application.Run "MyBook.xls!MyMacro"

If MyBook is not in the default directory, include the full path.

This will open MyFile.xls (if it is not open) and run its MyMacro routine.


---
Regards,
Norman



"Sylvain" wrote in message
...
Hi !

I can't find for the moment the VBA code to execute the sequence :
- open a workbook
- execute a macro stored in it

Thank you for your help

Best regards

Sylvain caillet