Running multiple macros on multiple .csv files from prompt

mellen

New Member
Joined
Apr 12, 2005
Messages
35
Hi,
I've written some macros that I wanted to run on multiple .csv files in various locations.
The steps that I would be looking to do were:
For every *.csv in .\
Open file, run macro 1, 2 (assume the macros are called "Macro1" "Macro2" ... etc.
Save file
Close file
Thanks in advance
Mellen
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Watch MrExcel Video

Forum statistics

Threads
1,119,263
Messages
5,577,055
Members
412,763
Latest member
sienweiw
Top