I'm processing a series of report files to turn them into tables, saving the
tables (workbooks), combining the tables into one composite workbook. This
will happen daily. I want to avoid the irritating messages that a file with
this name already exists. I don't see any way to make the .saveas prevent
that, and haven't found a reliable way to delete the files just before the
..saveas.

I thought surely the shell() function would do it with "del filename.ext",
but it didn't want to hear that. I even made a batch file to delete the
files, but it does it the first time through the program, then quits. It
seems there should be a more elegant way than a batch file anyway.

What am I missing?

Thanks,
Dave Dawson

There's a Kill command that can delete a file. Help seems to have plenty of
information on it.

Chris


On 4/2/05 2:40 PM, in article , "Dave
Dawson" wrote:

I'm processing a series of report files to turn them into tables, saving the
tables (workbooks), combining the tables into one composite workbook. This
will happen daily. I want to avoid the irritating messages that a file with
this name already exists. I don't see any way to make the .saveas prevent
that, and haven't found a reliable way to delete the files just before the
.saveas.


I thought surely the shell() function would do it with "del filename.ext",
but it didn't want to hear that. I even made a batch file to delete the
files, but it does it the first time through the program, then quits. It
seems there should be a more elegant way than a batch file anyway.

What am I missing?

Thanks,
Dave Dawson

You want the kill function.

kill "C:\Myfile.txt"

You can also use file system objects but that is a lot more work than you
need. To get rid of the annoying message use this line of code:

application.displayalerts = false

be usre to turn it back on when you are done...

application.displayalerts = true

HTH

"Dave Dawson" wrote:

I'm processing a series of report files to turn them into tables, saving the
tables (workbooks), combining the tables into one composite workbook. This
will happen daily. I want to avoid the irritating messages that a file with
this name already exists. I don't see any way to make the .saveas prevent
that, and haven't found a reliable way to delete the files just before the
..saveas.

I thought surely the shell() function would do it with "del filename.ext",
but it didn't want to hear that. I even made a batch file to delete the
files, but it does it the first time through the program, then quits. It
seems there should be a more elegant way than a batch file anyway.

What am I missing?

Thanks,
Dave Dawson