Opening Files, Selecting Specific Data, Pasting to Table

[jasonmac]

Hello Everyone.

An interesting problem has come up at work. Our report generating software created a report that produced 799 ".csv" files and places them in a folder. These files contain a single cell that holds the "Total Sales" for a specific store. I need a way to open each file, select the total sales, and place it in a table or a spreadsheet or something. Can anyone think of something?

Thanks in advance,
Jason

 

[HarleyQuinn]

I would suggest adding a reference to 'Microsoft Scripting Runtime' and doing a search on this Forum for 'FSO'. That should point you in a good direction for extracting the data from the .csv files.

Hope this helps

Harleyquinn

---------------------------------
For tsunami relief donations