View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Paul is offline
external usenet poster
 
Posts: 661
Default How to create a new folder using Excel VBA?

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