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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!