Posted to microsoft.public.excel.programming

external usenet poster

Posts: 27

How to check for the existence of the Temporary folder namedTemporary Folder 1,2 and so on As

Hi All,

I am using the below code:

FSO.deletefolder Environ("Temp") & "\Temporary Directory*", True
Set FSO = CreateObject("scripting.filesystemobject")
FSO.DeleteFolder Environ("Temp") & "\Temporary Directory*", True

Problem is that I want to check for the existence for the Temporary
Directory* means Temporary Diectory a and b ans so on, can i check for
the existence of folder before deleting as the name here is not fixed.

Regards,

Yuvraj

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Save file in a new folder, but create folder only if folder doesn't already exist?	nbaj2k[_40_]	Excel Programming	6	August 11th 06 08:41 PM
Check if folder exists, if yes just copy sheet in to folder?	Simon Lloyd[_787_]	Excel Programming	3	June 19th 06 03:44 PM
Temporary Folder Location	Bill[_30_]	Excel Programming	2	January 5th 06 11:08 PM
Can VBA clear the Temporary Internet File folder?	quartz[_2_]	Excel Programming	1	December 3rd 04 11:57 PM
Checking for the Existence of a Folder	Viswanath Tumu	Excel Programming	2	April 19th 04 08:31 AM

All times are GMT +1. The time now is 10:42 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us