Need to execute VBA code @ 9:30:01 exactly

Hello all. Using Excel 2003 with WinXP. I'm trying to run macro code automatically whenever time = 9:30:01 (or whatever time I pick) for a stock market trading program, which is why the exact time matters so much. I've been able to get the time to update fine, but unless I click on the worksheet while the time condition is TRUE then my code doesn't run. The time actually is sent to me from the stock data provider and it shows up in a cell as a constantly updating value.

I've tried using the Workbook_SheetChange function and OnTime method, but without luck. In both cases, unless I activate the sheet the code doesn't run. By activate, I mean that I have to click on the sheet when the values that trigger the code to run would be true. If I do that it works just fine, but sitting around and clicking on a worksheet defeats the purpose of automation. Since I'm trading stocks this has to be very exact, so I can't trust a macro scheduler to do this.

The code further below is what I'm trying to get to run. The time value is in cell L1. In cell L2 I have the following code:

Please Login or Register  to view this content.

That turns to True at 9:30:01 and false before and after that time. The code below checks cell L2 and then runs the code below that. It works just fine when I click on L2 and the result is True, but unless I manually "activate" the cell the result will turn to True but not run the code.

Placed in ThisWorkbook:

Please Login or Register  to view this content.

Any help on this would be greatly appreciated. Thanks.

That looks great. I'll try it ASAP. The code that was suggested I try for OnTime previously looked nothing like what you have below. Thank you very much!

Originally Posted by mudraker

To have a macro un at a specific time you will need to use the Application.OnTime command

Please Login or Register  to view this content.

Please Login or Register  to view this content.

SHG, I 'm no good at VBA, but wondering if this function is based on the PC's clock. If this one is not synchronized with stock market trading times, maybe the OP 's macro won't run at the right moment?

Originally Posted by jkupfer

The time actually is sent to me from the stock data provider and it shows up in a cell as a constantly updating value.

How is this done? That would solve the problem that I have:

My company has several different work sites and the computers are not networked. I have created a workbook that works well as a clock in/out device. The only weakness is that it relies on the clock of individual computers which obviously can be changed prior to clocking in and out. If there is a way to direct Excel to use the date and time from a website then it's good to go.

Hi Forum Friends
I would like to start a macro at 9:47 A.M. automatically. Much like the posting in
http://www.excelforum.com/excel-prog...1-exactly.html
I tried to use the code as in #7 (2nd reply by shg).
If I insert the code I get variable not defined error for ThisFile in the code below and for
letters x, y, z etc which I use as counters frequently. Can solve the latter by defining them.
Without the On Time code my macros were working fine.
My Question, is there a simple On Time procedure that would start a macro at 9:47 and does not cause the define error?

My SaveAs_Master macro saves 3 copies of the workbook in 3 diffrent drives.

HTML Code: 

Please Login or Register  to view this content.