Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to run one macro in all the excel files
Hi................
I have created a macro and want to run that macro in all the excel files. But to that I have to open the file that contain the macro every now and then I want to avoide that. Is there any way to do that.................... Regards, Kashif Khan |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to run one macro in all the excel files
select 'This Workbook' while creating the macro.
wrote in message oups.com... Hi................ I have created a macro and want to run that macro in all the excel files. But to that I have to open the file that contain the macro every now and then I want to avoide that. Is there any way to do that.................... Regards, Kashif Khan |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to run one macro in all the excel files
Put it in your personal.xls file.
windows unhide and there should be a personal.xls file. if not run the macro recorder and save a dummy macro in the personal macro file. Then go to the editor and open the personal macro file and put the code in there. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. " wrote: Hi................ I have created a macro and want to run that macro in all the excel files. But to that I have to open the file that contain the macro every now and then I want to avoide that. Is there any way to do that.................... Regards, Kashif Khan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run multiple excel files off of one macro. | Excel Discussion (Misc queries) | |||
Run multiple excel files off of one macro. | Excel Worksheet Functions | |||
problem with import files by excel macro | Excel Discussion (Misc queries) | |||
problem with import files by excel macro | Excel Discussion (Misc queries) | |||
Macro to copy range from Excel files in folder | Excel Discussion (Misc queries) |