excel scheduler

  • Thread starter Thread starter Rod Good
  • Start date Start date
R

Rod Good

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
 
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,

I read Katherine's suggestion and I found that the suggestion to
reduce your security level to the minimum to be dangerous given the
propensity for hackers to exploit MS software. Here is my suggestion.
I use this everday at work and it runs like a champ.

1. Search your pc for the following 2 files. MakeCert.exe
and SelfCert.exe.

If you don't have these files you should be able to
install them using the ADD/REMOVE program they should
be under a heading of like security, digital signature,
or something along those lines. Install them.

2. Once done run the SelfCert.exe file and create a self-
signed Digital Signature.

3. In your XL VBE project in the Tools Menu there is a
a digital signature option. It should now show the
certificate which you just created. Assign it to the
project.

This will allow you to maintain your security level
settings and still have a workbook execute macros when
unattended.

4. I have currently 7+ workbooks which run on an hourly
basis utilizing this method and they run without issue.
 
Back
Top