Hi Bob,

There are a couple of ways to do this, but the simplest one is to use
the MkDir statement:

MkDir "C:\MyFolder"

Note that you can't create multiple folder levels al at once using this
method (e.g. C:\MyFolder1\MyFolder2). For that you need to use the Windows
API or FileSystemObject.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"Bob C." wrote in message
...
I have created a software tool that operates from a
Microsoft Excel platform using Visual Basic programming.
This tool creates reports from data in an Excel Workbook.
Once the report is generated, I want to create a unique
folder on my server and save the document to the new
folder. Saving the document is no problem but how do I
create a new folder on the server to save the document
to? I want to encode this using visual basic in my excel
module using unique data from the workbook to create the
name of the folder. Can anyone help solve this problem?