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