Join or sign in Register for your free TechRepublic membership or if you are already a member, sign in using your preferred method below. Use Your Email Use FacebookUse Linkedin

Closing Excel with Windows Scheduler

Locked

I have set up a VB macro on an excel spread sheet that will update the sheet, create a web page and then save and close the worksheet automatically. I give it a couple of minutes after the save/close and then I tell the scheduler to end excel but I get an error telling me to expand the wait time. I have done that but I get the same error on expanded values.

Topic

Reply To: Closing Excel with Windows Scheduler

In reply to Closing Excel with Windows Scheduler

What are you trying to ack? Close all files at night?
There are alternatives to scheduler that can be klugie at the best of times.
Send email and I can send some code to assist.
Steven_v_brown@hotmail.com

[Author]

Replies