add multiple CVS files to an existing work book

[dpierce4776]

Hello all
I don’t know if this is possible but I am trying to take several CSV files and convert them into a single pre existing workbook. The pre existing work book has a summary sheet that will pull information from all the imported sheets.
The basic work flow is
Report is dumped into a dir as a txt file
My batch file converts the txt into a CSV
I have a work book that has the summary sheet built in as sheet one.
What I am trying to do is that when the reports are dumped in the new data will replace the old data in the summary workbook.

 

[markdmac]

Seems like the best course of action would be to have the summary sheet have formulas that will automatically update when the data is updated on the other sheets. I think you should focus on importing the data into the assigned tabs.

I hope that helps.

Regards,

Mark

No trees were harmed in posting this message, however a significant number of electrons were terribly inconvenienced.

Check out my scripting solutions at

http://www.thespidersparlor.com/vbscript

Work SMARTER not HARDER.