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 |
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 |
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 |
All times are GMT +1. The time now is 10:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com