Excel. My module saves as. But if the file doesn't exist it bonks 1

[coolcarls]

So, thanks for all the help. Everything is done and working. I now am being a little anal.
The module saves my workbook in a folder "C:\Projects\Pyramid Docs" _& "\BOLLA04-
" & Sheet2.Cells(3, 13).Value & ".xls"
A little cumbersome, but it works.
The only probem is, that the folder actually has to exsist in the "C" drive. If it does not, is there a way to have a dialogue box come up and ask the user if they would like to create a new folder, and if so, where and what to name it?
Thanks a lot.
Carl

 

[xlbo]

have a look at the MkDir function

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[coolcarls]

YEAAHHH! THAT'S IT! All done! Thanks so so much
Here's a star for you Mr. Geoff