| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Run macro when file is opened and closed | Excel Programming | |||
| How to change closed file name - Error: file not found | Excel Programming | |||
| Excel is not asking to save a changed file when the file is closed | Excel Discussion (Misc queries) | |||
| VBA - on a button event, open another closed file, post changes, close file | Excel Programming | |||
![Peter[_61_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
