I need help deleting a file from within VB6.

[elmorro]

I have an excel file that I need to delete when my program is ran. I tried using the following code:
Kill "C:\ExcelFile.xls"
but it did not work.

How can I accomplish this.

Thanks in advance,
elmorro

 

[HughLerwill]

Did you get an error message; if so what was it?

 

[Golom]

Usually you want

FN = "C:\ExcelFile.xls"

If Dir(FN) <> "" Then Kill FN

"Kill" will raise an error if you attempt to use it on a file that doesn't exist.

 

[elmorro]

HughLerwill,

I kept getting an access denied error. But I change file path and it works now.

Thanks.

 

[elmorro]

Golom,
Thanks for the code.
I am also using the following code to save the file:
objWorkBook.SaveAs "C:\ExcelFile.xls"

But if the file is an existant file it pops the following message:
The file already exists, would you like to replace it?

Is there anyway to stop this message from appearing?

Thanks in advance,
elmorro

 

[Swi]

Just use Golom's code before your code:

FN = "C:\ExcelFile.xls"
If Dir(FN) <> "" Then Kill FN
objWorkBook.SaveAs FN

Swi

 

[elmorro]

Thanks Swi,

I will do as you suggested.

elmorro