Calling a macro from a closed file
 

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

Calling a macro from a closed file
 

Hi Peter,

See the Run method and example in VBA help.


---
Regards,
Norman


"Peter" wrote in message
oups.com...
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

Calling a macro from a closed file
 

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Peter" wrote in message oups.com...
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

Calling a macro from a closed file
 

On 10 May, 16:59, "Ron de Bruin" wrote:
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



"Peter" wrote in ooglegroups.com...
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- Hide quoted text -

- 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

Calling a macro from a closed file
 

How about creating an addin that you can distribute?
--
HTH...

Jim Thomlinson


"Peter" wrote:

On 10 May, 16:59, "Ron de Bruin" wrote:
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



"Peter" wrote in ooglegroups.com...
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- Hide quoted text -

- 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

Calling a macro from a closed file
 

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"


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Peter" wrote in message oups.com...
On 10 May, 16:59, "Ron de Bruin" wrote:
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



"Peter" wrote in ooglegroups.com...
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- Hide quoted text -

- 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