Automation of running excel macros
Solved/Closed
aml
-
Mar 5, 2010 at 03:05 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 8, 2010 at 04:55 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 8, 2010 at 04:55 PM
Related:
- Automation of running excel macros
- Macros in excel download - Download - Spreadsheets
- No signal on monitor but cpu running - Guide
- Spell number in excel without macro - Guide
- Excel date format dd.mm.yyyy - Guide
- Excel free download - Download - Spreadsheets
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 5, 2010 at 03:37 AM
Mar 5, 2010 at 03:37 AM
Ok two things.
1. excel cannot by its own fire up and start execution of code. For that you need some thing else that is running to start excel. What you have read is suggesting to use ""Scheduled Tasks" to do that.
2. Once the excel open up, macro can be embedded in excel to immediately fire up. This is triggered by an event called "open". Basically it is sub routine named "Auto_Open"
Sub Auto_Open()
... <code goes here>
End sub
Hope it clarifies things for you
1. excel cannot by its own fire up and start execution of code. For that you need some thing else that is running to start excel. What you have read is suggesting to use ""Scheduled Tasks" to do that.
2. Once the excel open up, macro can be embedded in excel to immediately fire up. This is triggered by an event called "open". Basically it is sub routine named "Auto_Open"
Sub Auto_Open()
... <code goes here>
End sub
Hope it clarifies things for you
Apr 8, 2010 at 04:22 PM
Apr 8, 2010 at 04:55 PM
Application.OnTime TimeValue("07:00:00"), "my_Procedure"
Which basically says at 7 execute this procedure.