A Macro Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CW - 18 Dec 2006 05:59 GMT

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?

Reply to this Message

Martin Fishlock - 18 Dec 2006 08:19 GMT

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.

Signature

Hope this helps
Martin Fishlock
Please do not forget to rate this reply.

> 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
[quoted text clipped - 3 lines]
> processes on Sunday nights automatically so that this file will be
> downloaded when I get to work on Monday?

Reply to this Message

Bob Phillips - 18 Dec 2006 09:44 GMT

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.

Signature

---
HTH

Bob

(change the xxxx to gmail if mailing direct)

> CW try using scheduled tasks on the control panel.
>
[quoted text clipped - 17 lines]
>> processes on Sunday nights automatically so that this file will be
>> downloaded when I get to work on Monday?

Reply to this Message

Rate this thread: