starting macros via scheduled tasks

M

mnichols

I have an excel spread sheet open 24/7 logging data. Once a day I us
application.OnTime to run a macro. However this VB code is embedde
within the excel spread sheet.

Is it possible to start the same macro once a day using the window
scheduled task as opposed to using any vba code
 
F

Frank Kabel

Hi
one idea:
- put your code in the workbook_open event of your file
- open this file with the Windows scheduler
- also close the file in the workbook_open event
 

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

Accessing Exchange via Task Scheduler run on a Server 0
Windows Scheduled Tasks 1
Excel template that is able to collect data from other excel sheetsbased on different criterias 0
Access 2003 and excel 0
Scheduling a Macro 4
Automatically clear web query message "unable to open http:" 1
Schedule downloads in VBA 5
Schedule Downloads 0

Top