Run excel workbook and macro automatically

Closed
smd - Aug 10, 2009 at 03:54 AM
kaiyasit Posts 30 Registration date Sunday August 9, 2009 Status Member Last seen April 20, 2010 - Aug 10, 2009 at 04:45 AM
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 response

kaiyasit Posts 30 Registration date Sunday August 9, 2009 Status Member Last seen April 20, 2010 12
Aug 10, 2009 at 04:45 AM
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