Thanks Tom and Amedee you guys were a create help.

Regards
Bob

"Bob Phillips" wrote:

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