Calling a macro from a closed file

[Peter]

Hi all!

Does anyone know how to call a macro from a closed file and then run
that macro? I have tried recording it but no luck.

Any help would be much appreciated.

Peter

 

[Norman Jones]

Hi Peter,

See the Run method and example in VBA help.

 

[Ron de Bruin]

You must open the file to run a macro
Why not add the macro in your personal.xls file so you can use it in all your workbooks.
See http://www.rondebruin.nl/personal.htm

Or is there a other reason

 

[Peter]

You must open the file to run a macro
Why not add the macro in your personal.xls file so you can use it in all your workbooks.
Seehttp://www.rondebruin.nl/personal.htm

Or is there a other reason

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm








- Show quoted text -

Sorry that won't work as it will be used by a number of people across
a network. I can find the run method in the help. Any other
suggestions?

Thanks,

Peter

 

[Guest]

How about creating an addin that you can distribute?

 

[Ron de Bruin]

Hi

Try Jim's suggestion
See Dave"s example on Debra's site
http://www.contextures.com/xlToolbar02.html

Run you use like this if the workbook is open
Application.Run "template.xls!MyMacroName"