Scheduling excel macros
Closed
smd_excel
Posts
27
Registration date
Saturday April 18, 2009
Status
Member
Last seen
November 22, 2012
-
Sep 3, 2009 at 01:06 AM
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 - Sep 3, 2009 at 11:30 AM
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 - Sep 3, 2009 at 11:30 AM
Hello,
i have used windows scheduler to open the workbook every night at 12
i need to run a particular macro from a particular module.
in my auto_open event i already have 3 macros which will run on start up. i need to skip these three macro and run my specific macro every night.
any help will b highly appreciated.
i have used windows scheduler to open the workbook every night at 12
i need to run a particular macro from a particular module.
in my auto_open event i already have 3 macros which will run on start up. i need to skip these three macro and run my specific macro every night.
any help will b highly appreciated.
Related:
- Scheduling excel macros
- Macros in excel download free - Download - Spreadsheets
- Excel mod apk for pc - Download - Spreadsheets
- Excel online macros - Guide
- Number to words in excel - Guide
- Gif in excel - Guide
1 response
sharpman
Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
183
Sep 3, 2009 at 11:30 AM
Sep 3, 2009 at 11:30 AM
hit f1 in excel
type these words into the search box
auto_open macro event excel
go down the list until you get to run a macro.
in there it mentions that if you try your nightly macro in vba instead it over rides auto_open macros, so those other 3 would not run.
have a read see if it helps.
sorry, you did not mention which office version you are using. the above is for 2007, but i'm sure there would be a similar solution in previous versions.
type these words into the search box
auto_open macro event excel
go down the list until you get to run a macro.
in there it mentions that if you try your nightly macro in vba instead it over rides auto_open macros, so those other 3 would not run.
have a read see if it helps.
sorry, you did not mention which office version you are using. the above is for 2007, but i'm sure there would be a similar solution in previous versions.