Glad you like it. Here's the code for the delays;
[code]
'public sub to allow delayed timings to be used in other code
Public Declare Sub Delay Lib "kernel32" Alias "Sleep" (ByVal dwMilliseconds As Long)
[/code]
So the sub itself is called "Delay" and the number is a wait time in Milliseconds. To pause for one second you enter a line as "Delay 1000".
If you want this to run every 15 minutes there are two options;
1. use Task Scheduler
You can use windows task scheduler to set the Excel workbook to run at a particular time of day, and every 15 minutes after. Because the CCPulse reading macro needs to interact with the screen it has to run within a normal user session. For this reason you can't have Task Scheduler call the Excel sheet directly as it runs in a hidden session. Instead use Task Scheduler to call a batch file and use that batch file to run the Excel workbook.
Batch file; open Notepad and type in 'call', then the full path to your excel book. Save this with the extension .bat and then point Task Scheduler to this file to run it.
[code]
call "c:\ProgramData\Reporting\CCPulse Reader.xlsm"
[/code]
Hint: you'll also need to set the macro up to run when the workbook is opened
2. use the delay code and call the macro from within itself
Instead of using Task Scheduler you could end the earlier macro with
[code]
Delay 900000
Call CCPulse_reader
[/code]
A note of caution though... This will need to be tuned to subtract the time it takes for the main macro to run on your machine. If you don't tune it the code will run, then it will wait 15 minutes, then it will run again you will quickly lose sync with the intervals.
Remember also that the main macro will [b]overwrite[/b] the saved files so you will need to hive these off between the intervals or you'll lose them.
