Delete the active wb

's Computer Specifications

Hello all,
The last touch to my macro is to delete the log file from which I've
extracted the infromation and then saved as a text file.

Here is the command I use:

Sub DeleteOrigFile()

Workbooks(strCurrentOrigFileExt).Delete

End Sub

Do you need more info?

Thanks

's Computer Specifications

Nevermind,
I've used Ron de Bruin command and it worked perfectly

Kill strOrigDir & strCurrentOrigFileExt

thanks Ron

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Delete all sheets except the active one...?	derobin	Microsoft Excel Programming	1	22nd Jun 2006 04:02 PM
How can I delete a macro when the Delete button is not active?	=?Utf-8?B?RkNS?=	Microsoft Excel Worksheet Functions	0	9th Mar 2006 09:43 AM
VBA Delete a row in active sheet Please help	Alexandre	Microsoft Excel Discussion	2	8th Jun 2005 03:42 PM
Cannot delete active ip route	=?Utf-8?B?U2NoaWtvcmE=?=	Microsoft Windows 2000 Networking	1	22nd Oct 2004 02:45 PM
Delete active X	Steve	Windows XP Security	1	26th May 2004 09:17 PM