deleting a file through VBA

's Computer Specifications

Hi, I am trying to delete a file using VBA. Here is the situation. I
have code that opens a file, called say ABC. The code then makes
changes that I have specified and at the end saves the file as ABD
( dd-mm-yyy). What i am trying to do is have the code then delet the
original file as well since there is no longer a need for it. Anu
ideas?

Thanks

's Computer Specifications

On Sep 18, 2:28*pm, pat67 <pbus...@comcast.net> wrote:
> Hi, I am trying to delete a file using VBA. Here is the situation. I
> have code that opens a file, called say ABC. The code then makes
> changes that I have specified and at the end saves the file as ABD
> ( dd-mm-yyy). What i am trying to do is have the code then delet the
> original file as well since there is no longer a need for it. Anu
> ideas?
>
> Thanks

Never mind I found the Kill code.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Win2K SP4 and Error Deleting File or Folder. There has been a sharing violation. The source or destination file may be in use.	Toni Fontenele	Microsoft Windows 2000 File System	1	19th Nov 2010 08:47 PM
An Automated process of watching a network file folder, reading a file in it and deleting the file using ASP.NET ?	Luis Esteban Valencia Muñoz	Microsoft ASP .NET	3	4th Jun 2005 11:56 AM
Deleting a file location path under tools, options, file locations	=?Utf-8?B?ZWpl?=	Microsoft Word Document Management	1	11th Feb 2004 08:54 PM
Windows 2000 SP4 and Error Deleting File or Folder. There has been a sharing violation. The source or destination file may be in use.	Toni Fontenele	Microsoft Windows 2000 File System	0	5th Sep 2003 01:48 PM
Re: I am Back... Error Deleting File or Folder. There has been a sharing violation. The source or destination file may be in use.	Toni Fontenele	Microsoft Windows 2000 File System	0	27th Aug 2003 01:58 PM