Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro that runs for multiple files
You could record and store a macro then save it to your personal macros.
Assigning a hotkey to this would mean you could load any file and press the relevent key combination to execute the macro. Just remember to save the changes to personal.xls when prompted. However even this may be tedious for 60 files. Depending on the complexity you could wrap the operation you want to perform into a macro then write a function which loads all the workbooks in a directory (for example) one by one and executes the macro on each (saving as you go if required). This is obviously more demanding but certainly possible and maybe necessary depending on what you want to do. -- Regards, Bill Lunney www.billlunney.com "igor" wrote in message ... Hi, here is my issue, pleeeease help. i have 60 files that are formated identically. i need to make the same changes to all of them without copying and pasting the code into each individual file. can anyone help please. Thank you Igor |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA macro runs fine, but freezes if I try to do ANYTHING else whileit runs | Setting up and Configuration of Excel | |||
Macro: Filter Multiple header then extract to Multiple Files | Excel Discussion (Misc queries) | |||
One macro runs then it auto runs another macro | Excel Discussion (Misc queries) | |||
Can you code a macro so it runs multiple times in the same workboo | Excel Discussion (Misc queries) | |||
Excel runs, but files will not open | Excel Discussion (Misc queries) |