USD 15 VBA Macro To Create A Scheduled Task That Runs Only At Specific Time Interval

**EXCELERATION** · 08-05-2013, 01:56 AM

To Create Macro That Would Open up Excel 2007 at specific start and end time(s) or specific time intervals for a specific spreadsheet. There would be multiple spreadsheets, so I just need 1 template that I can modify for each spreadsheet in question.

- Run the macro within that spreadsheet.
- Save spreadsheet.
- Close spreadsheet.

- Excel can be open at all times if this helps.

Thanks !

**Excel Fox** · 08-05-2013, 02:49 AM

So what is the macro required? How will the macro know which spreaasheet to modify? Also, can you share exactly what you are trying to do here?

**EXCELERATION** · 08-05-2013, 03:10 AM

Ideally, the macro would run in Windows and would initiate the opening of a specific spreadsheet at a certain time. From there it would run a specific macro within the spreadsheet. One completed, it would be saved and closed. Two possible types of spreadsheets would be involved.

1. Specific time to be opened each day - run macro with spreadheet. Then close.
2. Always open, but running in intervals with intervals to determined by myself in minutes and seconds.

Hope that clarifies you question.

**EXCELERATION** · 08-05-2013, 03:12 AM

**Excel Fox** · 08-05-2013, 05:59 AM

Somewhat. but it doesn't say what exactly needs to be done.

**EXCELERATION** · 08-05-2013, 06:13 AM

I can upload a sample speadsheet that might give you more insight. I just do not know how to do that within this forum. Any suggestions, or can I email it directly to you ?

**Excel Fox** · 08-05-2013, 06:31 AM

go to bottom of the editor panel and click the advanced button. now scroll down a bit and you'll see a button for attachment. be weary of file size.

**EXCELERATION** · 08-05-2013, 07:00 AM

Here you go....

This is a small template of one of many spreadsheets that I have.

In this case, currently I need to go in and activate it manually on a daily basis. Further, I have to stop it manually as well. Ideally, I would want this to start at a certain time and finish at a certain time based on my inputted criteria that I can modify within the module on a daily basis. In this particular case, it downloads the info every minute....

**Excel Fox** · 08-05-2013, 07:16 PM

Code is ready. Please send payment to the paypal Id I will PM you, and I will post the solution here.

**Excel Fox** · 08-05-2013, 11:28 PM

Here's the revised file. You'll notice that I've added a control sheet for you to set the start time and end time of your scheduled activity (macro). When you close the workbook, it will ask you whether you want to make any modifications or not. In case you don't need that, you can take that code out. In addition, I've added an option for you to not initiate the macro next time that the workbook is opened. Just sent a TRUE/FALSE value in Cell B3 of the control sheet.