How to delete a file using VBA

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Graham Standring (graham.standring_at_sunderland.ac.uk)
Date: 06/15/04 

Date: Tue, 15 Jun 2004 17:19:03 +0100

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 spread***. 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.

Quantcast