Newbie: How should I run same commands on multiple .CSV files

[ballz]

I have a few .CSV files I would like to do some filtering, sorting, consolidating on, and then outputting onto a new sheet or Book. There are a few files I would like to do this on, so I would like to learn a process I can repeat.

I know how to program in C++ and was just going to parse the whole .CSV file and use arrays, but I would like to use excel so it looks nice and organized.

Can anyone give me some keywords I should google to do this? Macros? VB?

Thanks for any help.

[pjwhitfield]

Theres a few threads on here for dealing with files in VBA and loads about multiple files.

Heres one I can think of > http://www.excelforum.com/excel-prog...ml#post3902766

Also if you google "VBA file handling" and "VBA cycle files" should give you some hints & tips

The basis of your requirement though would be to write a macro that does what you want for one file (you may be able to do this by recording the macro) then when you've got that doing what you want, amend it to bring in the filename via a variable and find one of the many file handling loops to pull files from a directory, get their name and pass it to the macro.

[ballz]

Got it. Thank you.

I'm already working on writing the macro. Using Record macro to do some basic syntax discover and google if the syntax doesn't look robust enough.

Thanks again.

[pjwhitfield]

No worries, any further issues/queries just post them