On May 26, 6:51*am, "Robert Crandal" wrote:
On second thought......

I think I might NOT need to run a DOS script at all.
The DOS BAT file I had in mind simply overwrites
a file, or deletes that file and replaces it with a new
file.

Therefore, I guess my question should be, how can I
replace a target file after a Workbook is closed?

"Robert Crandal" wrote in message

...



After a workbook is closed, is it possible to run a
macro that executes a DOS BAT file? *How would
I do that?- Hide quoted text -

- Show quoted text -

Just open your Excel file from the .bat