ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Running a macro at a certain time (https://www.excelbanter.com/excel-discussion-misc-queries/15662-running-macro-certain-time.html)

Tam

Running a macro at a certain time
 
I would like to run a macro at 3.45pm everyday. How would I do it?


TIA

Tam



Jason Morin

Use the OnTime method. For examples, see VBA Help as well
as Chip Pearson's site:

http://www.cpearson.com/excel/ontime.htm

HTH
Jason
Atlanta, GA


-----Original Message-----
I would like to run a macro at 3.45pm everyday. How

would I do it?


TIA

Tam


.


Tam

It doesn't say how to run it at a certain time. I would like to run this
macro at 3.45pm

Thanks

Tam



Jason Morin

Um, did you read on-line help or go to Chip's website?
The instructions are pretty clear.
Jason

-----Original Message-----
It doesn't say how to run it at a certain time. I would

like to run this
macro at 3.45pm

Thanks

Tam


.



All times are GMT +1. The time now is 01:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com