Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Folder
How do you delete the following folder programmatically?
C:\test Thank you Todd Huttenstine |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Folder
Hey guys, I got it. Below is what I did to delete a
folder. In this case I changed the folder I wanted to delete to SMS Raw Data. Dim FS As Object Set FS = CreateObject("Scripting.FileSystemObject") FS.deletefolder ("C:\Documents and Settings\" & NN & "\Desktop\SMS Raw Data") Todd -----Original Message----- How do you delete the following folder programmatically? C:\test Thank you Todd Huttenstine . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Folder
Todd,
Try - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Sub Delete_Folder() Dim FS As Object Dim str_F As String str_F = "C:\Test" Set FS = CreateObject("Scripting.FileSystemObject") If FS.FolderExists(str_F) Then FS.DeleteFolder str_F MsgBox "Folder deleted" End If End Sub - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- Regards, Soo Cheon Jheong _ _ ^ąŻ^ -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
UNABLE TO DELETE FOLDER | Excel Discussion (Misc queries) | |||
Time based file/folder delete | Excel Discussion (Misc queries) | |||
delete all the contents (sub folders and files) in the temp folder | Excel Discussion (Misc queries) | |||
delete folder | Excel Programming | |||
fso delete folder | Excel Programming |