We run a number of sales sites and I am trying to automate stock control between them. I can export from the websites a CSV file with new orders (three separate csv files)
Now, I have created a workbook that grabs these three CSV files, collates the data. I then have to manually do a save as CSV file to be able to export the collated data (actually into a database to do some more jiggery pokery)
As we are getting busier, i really need this to be happening automatically every half an hour, or perhaps every hour
excel version is 2007 on Windows PC
So to the question, is it possible, if so how?
Every half an hour
Open Excel with a specific named workbook
The workbook would then automatically refresh from the CSV data sources
Then after say 30 secs to allow the updates to happen
Do Save As to save as a CSV file (overwriting without prompts the existing file)
Then close excel again without prompts
This loop would then be left running 24/7