Hi Rod,

Open the files and save them as a workspace (File--Save Workspace). Save
that workspace file to a new folder and make sure that only the workspace
file or other valid Excel files are located within that folder - FYI you
don't need to save the worksheets themselves in there if you don't want to.

Then within Excel go to Tools--Options and on the General tab tell Excel to
open all files within that folder that contains the workspace file.

You could use then Windows Scheduler to run Excel on a particular schedule -
by running Excel it would also then open that workspace, which would then
open the worksheets, but this would only automatically "run" the worksheets
(I'm assuming by this that you mean that your worksheets contain macros that
you want to run?) if the security level was set to low. Make sure that
you've considered the full effects of this before changing the macros
security level.

HTH,
Katherine

"Rod Good" wrote in message
om...
Hi,

I have several excel spreadsheets that I would like to run
automatically at pre-scheduled times throughout the day. Ideally I
would be able to access the results from the web, organised as a time
series. Is there a tool out there that can do this ?

Thanks,

Rod