Hey guys, i need some help automating a report. It needs to run 24/7 and perform macros every hour. I need the first line in the Starttimer sub to work properly. So if the current date and time is 10/23/2015 08:13:00, the code would generate the following
RunWhen= (2015,10,23)+(8,0,0)+(1,0,0) = 10/23/2015 09:00:00
Please Login or Register to view this content.
Try something like this...
RunWhen = Date + TimeSerial(Hour(Time) + cRunInterivalHours, 0, 0)
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks