Hi Expert programmers,
I have a one button macros VBA that resides in Excel 2007 which i ran every week. Now since there's no other tasked aside from pushing that one button every-week and let it finished I want to further automate it using Operating System Task Scheduler (Win7).
Is this viable?
If yes, could you please guide me where to start researching for answers.
Welcome to the forum.
I don't have Win7, but in XP, you'd schedule the workbook in Control Panel > Scheduled Tasks, and kick off the macro in the Workbook_Open event.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
I would have thought it is possible, although I haven't used Excel as a scheduled task.
1. you need to make the "click of the button" unnecessary. So put some code in the workbook_open event to run the same code as the button click.
2. log on as an administrator . Control panel and scheduler.
It is best to create a new folder in the scheduler. There is quite a lot to fill in but it is all fairly self explanatory. The spreadsheet goes in under actions.
3. give it a whirl.
Let me know how you get on.
Hope this was useful or entertaining.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks