Be aware that if you have a multi-level directory structure, you will need
to make each one separately
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Tom Ogilvy" wrote in message
...
On Error Resume Next
Mkdir "c:\Myfolder"
On Error goto 0
Then you are sure it exists.
--
Regards,
Tom Ogilvy
"Bob" wrote in message
...
I have a module that saves workbooks through VB, but sometimes the file
does
not exists, what can I do so that when the folder does not exists it
must
create the folder for the workbook?
Thanks
Bob