Deleting Files From VBA
 

As part of a macro I'm writing in EXCEL via VBA I need to
delete a file from a specfic location. Any Help?

Deleting Files From VBA
 

Try using Kill

Kill("C:\My Documents\File I don't need.xls")

Dan E

"Brett" wrote in message ...
As part of a macro I'm writing in EXCEL via VBA I need to
delete a file from a specfic location. Any Help?

Deleting Files From VBA
 

On Error Resume Next
kill "C:\My Documents\Myfile.xls"
On Error goto 0

--
Regards,
Tom Ogilvy

"Brett" wrote in message
...
As part of a macro I'm writing in EXCEL via VBA I need to
delete a file from a specfic location. Any Help?

Deleting Files From VBA
 

Brett,

Look up KILL in XL VBA help

HTH
Henry


"Brett" wrote in message
...
As part of a macro I'm writing in EXCEL via VBA I need to
delete a file from a specfic location. Any Help?