Workbooks.Open Filename:=wb_filename
Application.Run "'" & Activeworkbook.Name & "'!myMacro"

If the code is added to the workbook's Workbook_Open event, it will execute
automatically upon opening the workbook.


--

HTH

RP
(remove nothere from the email address if mailing direct)


"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