Scheduling an excel file to run everyday

  • Thread starter Thread starter Marc April
  • Start date Start date
M

Marc April

I am trying to scheduled a task to run a Excel file with
an "On open Macro". the worksheet work's perfexctly
when we run it normally, but as soon has we schedeled it
via de windows scheduler, the task goes in running mode
and never quit's. We created a smaller on open macro (
write 1 , 2 in 2 cells then saves and quit excel.
again work's great in normal mode, has soon has we
create a task for it it does not work !!! any hint's
 
Some version of XL had a problem (and I don't know if it has been
fixed) where certain types of VBA statements caused problems in the
Workbook_Open procedure. I don't know if this is causing your problem.

The workaround was to put the actual code in a separate procedure and
use the OnTime method to schedule this new procedure for zero seconds
later. For more on OnTime, check it out in XL help and/or visit Chip
Pearson's http://www.cpearson.com/excel/ontime.htm

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to run a MSQuery from Excel as a Scheduled Task 1
Automatically run an Excel macro 3
How to open 2 excel instances by using XP schedule tasks? 2
Schedule Macro doesn't seem to run any suggestions 3
Is there a way to force out other editors when Excel 2003 is inautomation mode? 3
Scheduling a Task to run Excel 1
Run a Macro at a certain time 2
How to code VBA: Auto open workbook and run macro 4

Back
Top