Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File System Object
Hi all, sorry that this is a lame question, but im a
newbie !! I want to create a dir on my HDD with the name taken from a cell in the spreadsheet, there is a createfolder method as below Syntax object.CreateFolder(foldername) The CreateFolder method has these parts: Description object Required. Always the name of a FileSystemObject. foldername Required. String expression that identifies the folder to create. What is the filesystemobject name that I am supposed to use ? Many thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
File System Object
Neil,
Try Dim FSO As Object Set FSO = CreateObject("Scripting.FileSystemObject") FSO.CreateFolder foldername -- Cordially, Chip Pearson Microsoft MVP - Excel www.cpearson.com "Neil" wrote in message ... Hi all, sorry that this is a lame question, but im a newbie !! I want to create a dir on my HDD with the name taken from a cell in the spreadsheet, there is a createfolder method as below Syntax object.CreateFolder(foldername) The CreateFolder method has these parts: Description object Required. Always the name of a FileSystemObject. foldername Required. String expression that identifies the folder to create. What is the filesystemobject name that I am supposed to use ? Many thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
File System Object
You can also just do
Mkdir foldername where folder name would contain something like "C:\My Documents\MyNewFolderName" -- Regards, Tom Ogilvy "Neil" wrote in message ... Hi all, sorry that this is a lame question, but im a newbie !! I want to create a dir on my HDD with the name taken from a cell in the spreadsheet, there is a createfolder method as below Syntax object.CreateFolder(foldername) The CreateFolder method has these parts: Description object Required. Always the name of a FileSystemObject. foldername Required. String expression that identifies the folder to create. What is the filesystemobject name that I am supposed to use ? Many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I open an Excel file on XP system, saved on a Vista system | Excel Discussion (Misc queries) | |||
The system cannot find the file specfied | Excel Discussion (Misc queries) | |||
How can i update the same excel file from three system? | New Users to Excel | |||
The System cannot find the file specified | Excel Discussion (Misc queries) | |||
the system cannot find file specified | Excel Discussion (Misc queries) |