OnTime Method error

shg: I wanted it to occur every day at that time, and I tested it at 5:10 pm, and it didn't run.

Leith: I am glad to know my syntax is correct, but then again it didn't even run when I coded the time into the macro. I have not called it from anything else. I thought I needed the open event to get it running.

Well ultimately I need the code to run at the time listed in the cell. Not incrementally from 12. Example: If the cell says, 2:45, then the code needs to run at 2:45.

Ok I got it to work hand coding the time when I ran it from a different macro.

I used this coding to call it:

Please Login or Register  to view this content.

OpenMaster macro:

Please Login or Register  to view this content.

This all worked fine, but when I changed it to reference a cell I had errors.

Please Login or Register  to view this content.

I put the if weekday in comments becasue when I tried to run that, it said argument was not optional.

After putting that in comments, I tried to run the macro, and the debugger highlighted the last line.

Shg: Thank you so much for correcting my syntax. It works perfect.

Now I just need to find a way to have it run at a different time Wednesday.

I knew the weekday= 3 was wrong.

I need a way to tell the code to run at the time posted in cell E11 if it is a Wednesday and cell E12 if it is a different day of the week.

Any ideas?

If the day the program is run is a Wednesday.

This program will be used Monday-Friday, and it needs to open the master at a different time on wednesday.

I used the second one, and while it ran with no errors for the time listed in E12 (the non-Wednesday time), I had troubles getting it run at the time listed in E11 when I changed the code to Thursday, so I could test it.

Instead I decided to do the following

1) On the sheet I typed =Today() in cell D2
2) On the sheet I typed =Weekday(D2) in cell D3
3) In cell E3 I created this formula =IF(D3=4, E11, E12)

Then I had the macro run at the time listed in cell E3.

So cell E3 will change to a different time on Wednesday (E11) and another time on the other days (E12)

I tested this, and it works.

Thanks for your help. I would not have been able to arrive at this conclusion without your help since you fixed my syntactical error.