Autorun macro

[Greed]

Hi all,

I already have the macro to autorun another macro:

Please Login or Register  to view this content.

But my question is this, is there a way to perform this if the workbook is closed? Ideally, I would like the macro to run in the middle of the night (2:00 AM) because I have found that my macro frequently gets hung up by users having forms open (they forget to close out properly) *the macro I want to run grabs a bunch of Word forms and populates the excel spreadsheet with the form fields*. I am hoping that if I can autorun the macro at night, I won't have this issue, but what I have read makes it sound as though the workbook has to be open for the code to work??

Thanks

[Leith Ross]

Hello Greed,

That is correct. The workbook must be open for any macros to run. You could use your Task scheduler to automatically load the workbook so it will run at the specified time. You will need to write another macro to close the workbook automatically, if needed.

[Greed]

Forgive my ignorance...what is a Task scheduler?

Also, I just completed a 'test'...I set the macro to a time (10 minutes ago) - left the workbook open (I did save, close and re-open the workbook) adn then went about my business, but nothing happened. I currently have the macro in the 'sheet' portion of VBA. Is that where it belongs?
Thanks

[Greed]

Well, I found the Task scheduler and set it up for last night...nothing happened.
Also, the code isn't working at all when I attempt to test it and I'm not sure why or what to do to fix it. Any ideas?