Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Just trap the error - less work than testing.
On Error Resume Next mkdir "C:\MyDirectory" On Error goto 0 If your directory is several levels, then you might need to work down the structure On Error Resume Next mkdir "c:\Level1" mkdir "c:\Level1\Level2" mkdir "c:\Level1\Level2\Level3" On Error goto 0 If there might be a problem with permissions, then you might need to check for the existence after the above. -- Regards, Tom Ogilvy Jonefer wrote in message ... I'm trying to write a vb routine that will save a file in a certain directory. I want to test for the existence of the directory and create it if it doesn't exist, before saving the file. please help? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to automatically make excel detect directory path for linked f | Excel Discussion (Misc queries) | |||
Cell reference to make a directory path | Excel Worksheet Functions | |||
is there a add-on for excel to make mp3 list from directory | Excel Discussion (Misc queries) | |||
How do i make a telephone directory for the office | New Users to Excel | |||
How do I make a school directory? | New Users to Excel |