Hello, I need someone to create two files like below so I can complete the following task. I need to use windows scheduler to run a vbscript. The vbscript should do the following:
- Close all excel workbooks without messeges.
- Restart a specific workbook.
- Run a macro in this workbook.
- Save
Then end.
My understanding is I need two files:
- Vbscript (used to complete the excel tasks needed)
- .bat file (used in windows scheduler to run the vbscritpt)
Should be a very quick project for someone thats done this before e.g. 30 minutes.
Thanks
John
Actually you need only one vbscript file, because you can run vbscript from scheduler, but if you prefer to run it from batch (.bat) script, no problem.
Stay tuned, I'm still working on this proposal.
I have not done this before, but I have investigated this aspect before. I can develop the solution as required.
Relevant Skills and Experience
18 years experience in using Excel as part of daily work life. In the process, implemented lot of automation. Over the last 14 MONTHS , spent at least 250 HOURS on automation in Excel every month.
Proposed Milestones
£30 GBP - Windows scheduler solution to run macro
Hi bro
I can make a program meet your requirement.
Just click one button and everything done :)
Relevant Skills and Experience
AutoIt
Proposed Milestones
£23 GBP - Pass the POC
Please contact me and give me your specific workbook