ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Time Marco issue (https://www.excelbanter.com/excel-programming/426712-time-marco-issue.html)

Elton Law[_2_]

Time Marco issue
 
Dear Expert,
I want to set certain Excel macros to be run on scheduled time in a day.
This file contains those macros will be saved as add-in file so that
whenever Excel is "On", automated macros will be run on schedule time.
Just wonder how to write the scripts in VB ? Macros have been written
already, but now just need me to click "YES" or "Run" button. It is very
routine and clerical. Hope dear expert here can help me.

AltaEgo

Time Marco issue
 
http://www.brainbell.com/tutorials/m...A_Set_Time.htm

Still a learner after all those years.
--
Steve

"Elton Law" wrote in message
...
Dear Expert,
I want to set certain Excel macros to be run on scheduled time in a day.
This file contains those macros will be saved as add-in file so that
whenever Excel is "On", automated macros will be run on schedule time.
Just wonder how to write the scripts in VB ? Macros have been written
already, but now just need me to click "YES" or "Run" button. It is very
routine and clerical. Hope dear expert here can help me.



Elton Law[_2_]

Time Marco issue
 
Good JOB ... Thanks indeed.

"AltaEgo" wrote:

http://www.brainbell.com/tutorials/m...A_Set_Time.htm

Still a learner after all those years.
--
Steve

"Elton Law" wrote in message
...
Dear Expert,
I want to set certain Excel macros to be run on scheduled time in a day.
This file contains those macros will be saved as add-in file so that
whenever Excel is "On", automated macros will be run on schedule time.
Just wonder how to write the scripts in VB ? Macros have been written
already, but now just need me to click "YES" or "Run" button. It is very
routine and clerical. Hope dear expert here can help me.





All times are GMT +1. The time now is 10:05 PM.

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