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

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?

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

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

"Robert Crandal" wrote in message
...
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......



Maybe. If your users would consistently / reliably use a shortcut that
invoked a .BAT script which opened the workbook and waited for the
process to complete before continuing you would have a very simple
solution. << IF

Does the workbook in question actually need to be closed for the
operations to take place, or are the operations happening to a different
file?

If a different file, put the VBA code in the Workbook.Close event.

If the same file, post back and either myself or someone else can help
you design code that will run after your workbook has finished exiting.

--
Clif McIrvin

(clare reads his mail with moe, nomail feeds the bit bucket :-)

"Clif McIrvin" wrote in message
...

Does the workbook in question actually need to be closed for the
operations to take place, or are the operations happening to a different
file?

If a different file, put the VBA code in the Workbook.Close event.

If the same file, post back and either myself or someone else can help you
design code that will run after your workbook has finished exiting.


Basically, I need to put VBA code in Workbook.Close() that
deletes a file on the C: drive named "orders.txt". Then I need
to create a new replacement file named "orders.txt" which I
will write my own data into.

"Robert Crandal" wrote in message
...
"Clif McIrvin" wrote in message
...

Does the workbook in question actually need to be closed for the
operations to take place, or are the operations happening to a
different file?

If a different file, put the VBA code in the Workbook.Close event.

If the same file, post back and either myself or someone else can
help you design code that will run after your workbook has finished
exiting.


Basically, I need to put VBA code in Workbook.Close() that
deletes a file on the C: drive named "orders.txt". Then I need
to create a new replacement file named "orders.txt" which I
will write my own data into.



There are different tools available for doing this in VBA. I'm not at
all familiar with the FileSystem Object, but I did use the BASIC
statements such as OPEN, KILL, etc. years ago; and they are still
available in VBA.

Check the Visual Basic Language Reference in your on-board help for
syntax.

I don't have sample code at hand, but could throw together some air code
if you need it.

--
Clif McIrvin

(clare reads his mail with moe, nomail feeds the bit bucket :-)