A Macro Question

C

CW

I have a large Excel file that downloads and does some calculating. It
takes about a hour and a half for this to complete. Most of the time is
the calculating. This must be done early Monday mornings but the file
is completed by another dept on Sunday afternoons. There is a Macro
that activates the download. Is there a Macro that can start all the
processes on Sunday nights automatically so that this file will be
downloaded when I get to work on Monday?
 
M

Martin Fishlock

CW try using scheduled tasks on the control panel.

You will need to leave your machine on over the weekend.... or if you are on
a terminal server get your IT dept to set it up on the server.

Just select excel as the application and go to advanced options for it to
specify the file etc.

You will then need to set an auto open macro in it to run will a bit or
error checking etc.

Have fun trying it out.
 
B

Bob Phillips

If you go this route, make sure that you have good error handling, not just
output a MsgBox, as there will be no-one there to respond.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 
Top