Initiate Macro

**bartinp** · 10-02-2009, 05:50 AM

I created a macro that I wanted to run based on time. I'd like to use an IF statement combined with on of the time functions that would run this macro say every 20 minutes after the hour.
a) I haven't figured how to get a macro to run other than manually starting it.
b) i havent' figured out how to use the NOW() function that updates by itself

Any ideas?

**royUK** · 10-02-2009, 05:58 AM

You need to use the OnTime method, use the Forum search & you will find many examples

**bartinp** · 10-02-2009, 02:28 PM

Thank you very much. I tried it out and used

Please Login or Register  to view this content.

to initiate the macro at a certain time. That worked very well. How would I be able to set it to initiate at a specific time on a specific date?

**shg** · 10-02-2009, 02:50 PM

Please Login or Register  to view this content.

Please edit your post to add code tags.

**bartinp** · 10-05-2009, 08:29 AM

I have another challenge that I hope you can help me overcome. Using the above code, if I set it to run @ a certain time and date and I have another excel spreadsheet at the time. If errors out because it can't find the right spreadsheet.
For Example In The Code I'm Using:
Set RangeToPoke = Worksheets("Raw Data").Range("B2")
Can I specify more than that so it knows to run on the specific workbook? It runs fine in the background if I have any other program open, but if I have another excel spreadsheet it errors. Help Please!