View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob C. Bob C. is offline
external usenet poster
 
Posts: 4
Default Creating Folders from Excel Using OLE Automation

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?