I probably wasn't clear, so I'll reword my question:

Upon exiting a workbook, I need to run a VBA macro that
deletes and replaces a specified file (or overwrites the
contents of that file with new data). BAT files are out
of the picture now......


"James Ravenswood" 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