T
Tom Gribbin
If anyone could help me out here I would be eternally grateful.
I have scheduled a data I am using to retrive some information that I
require every day at a set time into a single excel spreadsheet. So
far so good – this works fine. However, every time the new updated
data is imported into the spreadsheet, it overwrites the exisating
data in the spreadsheet losing me the previous days data.
Is it possible to schedule a macro within windows to copy the file
which the data imports into and then paste it as a file with a new
name e.g. ‘data (dd-mm-yyyy)' so that I build up a folder containing
new files of each days data whilst the original file can just be
overwritten each day and only contain that days data.
I am using Windows 2000 Professional and presume I can use scheduled
tasks to do this but do not have a clue how to go about this. Any
advise would be really appreciated.
I have scheduled a data I am using to retrive some information that I
require every day at a set time into a single excel spreadsheet. So
far so good – this works fine. However, every time the new updated
data is imported into the spreadsheet, it overwrites the exisating
data in the spreadsheet losing me the previous days data.
Is it possible to schedule a macro within windows to copy the file
which the data imports into and then paste it as a file with a new
name e.g. ‘data (dd-mm-yyyy)' so that I build up a folder containing
new files of each days data whilst the original file can just be
overwritten each day and only contain that days data.
I am using Windows 2000 Professional and presume I can use scheduled
tasks to do this but do not have a clue how to go about this. Any
advise would be really appreciated.