Putting csv files contents into an area in spreadsheet

[Chrissirhc]

what would be the easiest way to do this in an automated fashoin?

Thanks,

Chris

 

[xlbo]

record yourself doing it with the macro recorder (Tools>Macros>Record Macro)

post the code back for advice on making it more general...

 

[Chrissirhc]

hehe thanks I actually started doing that. I just need to remember how to do certain things such as getting a dialogue that will allow me to navigate to a file and return a filename as a string... Do you know off-hand?

 

[xlbo]

That would be the 'GetOpenFilename' method

 

[HughLerwill]

Similar stuff in;

Importing multiple CSV files into Excel
thread707-1187154

Hope it helps, hugh