Scheduling excel macros

[Closed]
Report
Posts
27
Registration date
Saturday April 18, 2009
Status
Member
Last seen
November 22, 2012
-
Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
-
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.

1 reply

Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
182
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!