How to delete a file using VBA

G

Graham Standring

I am sure this must be a really easy process but I have searched and
searched for an answer without success.

I need to include a command in an Excel macro which will delete a file.
The name of the file will vary each time the macro runs but the path,
filename and extension are held in a cell in the spreadsheet. Note that
the file that I want to delete is not the Excel file which is running
the macro and it is not an open file. (It is actually a .txt file in a
different directory.)

Can anybody tell me what the code is?

I am using Office XP on Windows XP and also on Windows 2000.

Thanks in advance.

Graham Standring
University of Sunderland
UK.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro that will insert a simple text string in top cell of text file 1
display a file in excel by using vba 0
Can't delete file 3
Insert, copy, update, delete records through VBA 3
Hiding an Excel file using VBA 1
Open Word file with Excel VBA 2
How to call Excel add-in macro from a button… 1
Which Excel event to call when opening a .txt file 1

Top