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
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.
Related:

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
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.
0