-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I don't know how to start an Excel from a programmed start up
(scheduled), but, if you're getting the data from Access you can uses
Access' command-line startup switches to automatically run an Access
macro. That Access macro could export the data, using a query, to a
specific Excel s/s. The s/s file name can be controlled from access
using VBA.
IOW,
0. Create an Access macro that calls a VBA function (RunCode). The
VBA function will export the data to Excel (you'll have to create that
function, also).
1. Create a short-cut to Access w/ the proper start up switches that
run the macro created in 0 (see Access help).
2. Schedule the shortcut to start at the correct time (use the
Scheduler - Windows Administrative tools).
HTH,
MGFoster:::mgf
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBP8eXbYechKqOuFEgEQIu6gCePe63y3qGAb40P4h2IwcWuA 6vFcsAn19H
Njia8ZkOBVg0mmOU9szDmANs
=gl3q
-----END PGP SIGNATURE-----
Tom Gribbin wrote:
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.
Many thanks,
Tom Gribbin