Need help batch running an excel macro on .csv files and saving back to the same .csv

What I'm trying to do is run a small bit of macro code on all these files to clean them up so I can compile them into one large list. The command prompt "copy" works well with the csv's so I figured I would just keep them as csv.

Logically what I'm trying to do looks something like this:

Open all files in C:\dir\*.csv

If cell A6="cond" then

{Macro code 1}

else

{Macro code 2}

Save changes to *.csv

I have a light background in programming in other languages but no so much in VB so calling/editing/saving files is one of the big hurdles. I am well versed in the Turbo PASCAL programming language though, which is the rotary phone of programming languages.

something like

Please Login or Register  to view this content.