This isn't exactly an Excel question, but I figure that someone here will 1) know how to use batch files to get this job done, or 2) Know a better way to accomplish the same goal using VBA.

Here is my situation:

I have a workbook that I need to open each day at a set time. Most days the workbook will already be opened, in which case it will need to close and then reopen (which is the only way I've found to force a refresh of certain links). Other days (on holidays when the office is closed for instance) the workbook will be closed, and I'll just need to open the file.

I have a very similar situation where I use scheduled tasks and batch files to open two workbooks and then call a macro...but those files are always closed when the scheduled task runs.

Thanks for any help.
Dylan