Run excel workbook and macro automatically

Closed
Report
-
Posts
30
Registration date
Sunday August 9, 2009
Status
Member
Last seen
April 20, 2010
-
Hello,

i got a workbook with alot of macros in it. i need to open the workbook automatically every nite at 12 and run a particular macro and then close the workbook. there shud b no user intervention.

any help will be much appreciated.

thanks alot

1 reply

Posts
30
Registration date
Sunday August 9, 2009
Status
Member
Last seen
April 20, 2010
12
I think you can use ....
"Scheduled Tasks" in system tool of WinXp
and set up time to run your workbook

in your workbook ....you must create VBA to run your macro by use event "ON OPEN"

may be help u
4