| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running a macro on mulitple files
I want to run a macro which I have written on about 67 excel files in one
folder automatically. Is this possible? HOw? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Running a macro on mulitple files
Chris
You can open each file in the folder using the Dir function. See here http://www.dicks-blog.com/archives/2...-dir-function/ Then run the macro and close the file. -- Dick Kusleika Excel MVP Daily Dose of Excel www.dicks-blog.com Chris wrote: I want to run a macro which I have written on about 67 excel files in one folder automatically. Is this possible? HOw? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I append multiple sheets from mulitple xls. files. into 1 | Excel Discussion (Misc queries) | |||
| importing data from mulitple files in a directory | Excel Discussion (Misc queries) | |||
| Macro to create mulitple files | Excel Discussion (Misc queries) | |||
| compare mulitple fiels... then, order the files by header... then, save | Excel Programming | |||
| importing mulitple files | Excel Programming | |||
Linear Mode
