Scheduling macro to run at specific time

[dwhite30518]

I have the following code that find a specific email in my outlook and saves it to a destination on my desktop. I would like to automate this but I can not seem to get the code to work correctly or at all.

Please Login or Register  to view this content.

What do I need to change to make this event run Mon-Friday at 5:00PM?

[JBeaucaire]

Something like this:

Please Login or Register  to view this content.

[dwhite30518]

I have a possibly dumb question....once I create this macro and then run ot...do I have to have an excel workbook open or will it still run even if excel is closed?

[JBeaucaire]

That's a good question. I don't use "timer" macros like this, I prefer to keep control of such things. Should be an easy enough thing for you test, though, yes?

If that takes care of your need, please select Thread Tools from menu above and set this topic to SOLVED.