| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a directory from within Excel VBA
Hi all,
I'm creating a little VBA script within Ms Excel, wanting the script to change directory before writing a file, using the ChangeFileOpenDirectory method. It works fine. But what if the directory does not exist? Then I want the script to create it. Can you please tell me how I make it do so? Thank you very much in advance. Jo |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating directory for workbook | Excel Discussion (Misc queries) | |||
| Creating an excel macro to open and save sheets to a different directory | Excel Programming | |||
| Creating a macro that lists directory names within a directory.... | Excel Programming | |||
| saving/creating a directory | Excel Programming | |||
| Creating a directory from a date | Excel Programming | |||
Threaded Mode
