How to create a new folder using Excel VBA?

[Guest]

My users may or may not have a folder called "C:\Audits".
When they run a certain macro, it should check to see if the folder exists,
and if it does not, create it and then save As the open Excel workbook to the
Audit folder under a new name.

Any ideas on how to check for/create the Audit folder from within Excel?

TIA
Paul

 

[Kletcho]

Check out this previous discussion:

http://groups.google.com/group/micr...f+folder+exists&rnum=1&hl=en#dfd28cd18af11e58

 

[Guest]

This should work for you...

On Error Resume Next
MkDir ("C:\Audit")
On Error GoTo 0

 

[windsurferLA]

The prior replies would probably work..
You could also use variations on the following to test for existence of
directory. It would be true if no directory exists and a Make Directory
command would be appropriate.
If dir(“C:\Auditsâ€)<> “C:\Auditsâ€