View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
WBTKbeezy WBTKbeezy is offline
external usenet poster
 
Posts: 54
Default Create Folders From Excel

I have some code that saves several copies of a spreadsheet to a specific
folder and it works great. However, if the folder that is specified in the
code doesn't exist, it errors out. Is there a way to have the folders be
created via VB code to circumvent this? I have to create folders on a daily
basis, and this would save some annoyance.