Append Excel Workbook Data to New Workbook
Posted on 2011-03-20
About 3 times a week I run a query that saves a .CVS file to my computer that’s always named the same (Contract.CVS). This file has only one record each time its runs ($A$1:$T$1) and has no column headers. Each time I run the query, it’ll replace the Contract.CVS file (overwrites it with the same name) and has a new record in the same row/range. I’d like to keep each record in a separate spreadsheet so I can keep track of the data. The problem is:
- The file changes each time I run it and has only one row of data so I need to append each record (add each record on the next row of my tracking spreadsheet)
- The Contract.CVS file is closed (will need to extract the data from the closed file into my tracking spreadsheet…?)
- Will need a way to alert me of Contract.CVS file is changed/replaced and automatically open tracking spreadsheet and append the data
- In column "D" of the Contract.CVS file there is financial data that I'd like to total using my tracking spreadsheet
Is this possible to do? Thanks!