| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create Folders From Excel
Thanks Ron, simple and effective!
"Ron de Bruin" wrote: You can play with this Sub MakeDirectory() Dim Dirname As String Dim fs As Object Set fs = CreateObject("Scripting.FileSystemObject") Dirname = "C:\MyDir" If Not fs.FolderExists(Dirname) Then fs.CreateFolder Dirname Else ' do nothing End If End Sub -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "WBTKbeezy" wrote in message ... I have some code that saves several copies of a spreadsheet to a specific folder and it works great. However, if the folder that is specified in the code doesn't exist, it errors out. Is there a way to have the folders be created via VB code to circumvent this? I have to create folders on a daily basis, and this would save some annoyance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I create folders in explorer from an excel list | Excel Discussion (Misc queries) | |||
| Can excel automatically create folders | Excel Discussion (Misc queries) | |||
| Create list of folders | Excel Programming | |||
| Can anyone help me Create Excel list of files in windows folders | Excel Worksheet Functions | |||
| To create folders using VBA | Excel Discussion (Misc queries) | |||
Threaded Mode
