Use batch file to close workbook?
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1