Excel - Running macro on multiple files

[SIshaq]

Hello,

I need help in running a macro I stored in my personal.xls
It formats csv files I get from an outside vendor. Problem is I get around 100 to 200 of these on a given day, and I need a quick way of running the macro on all these CSVs without opening every single one of them.
Any help would be appreciated. Thanks!

 

[SkipVought]

Hi,

"I need a quick way of running the macro on all these CSVs without opening every single one of them."

1. Store all your NEW csv files in one folder.

2. record a macro IMPORTING (not opening) Data > Import External Data > IMPORT[/b]

3. Post your requirements and recorded macro code in formu707, for help with VBA (macro) celd.

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[SkipVought]

Sorry, post in Forum707.

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]