How do you delete an exported file from a directory

I want to delete an RDF text file that I export from Excel which is in the
same directory as the Excel spreadsheet. In the beginning of the program, I
want to delete this file so that it doesn't accidentally append new
information. How do I delete this file using code?

Look at the Kill command in VBA help.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Brett Smith" <BrettSmith@discussions.microsoft.com> wrote in message
news:88562BC6-51D3-4A06-BC46-D08DCA9642F2@microsoft.com...
> I want to delete an RDF text file that I export from Excel which is in the
> same directory as the Excel spreadsheet. In the beginning of the program,
I
> want to delete this file so that it doesn't accidentally append new
> information. How do I delete this file using code?

Use the command Kill "FullpathAndFilename"
--
Kevin Backmann


"Brett Smith" wrote:

> I want to delete an RDF text file that I export from Excel which is in the
> same directory as the Excel spreadsheet. In the beginning of the program, I
> want to delete this file so that it doesn't accidentally append new
> information. How do I delete this file using code?