View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
simonc simonc is offline
external usenet poster
 
Posts: 52
Default Selecting an output folder

Is there an equivalent dialog to GetSaveAsFilename which will just select the
folder to save a file in instead of returning a full filename? The intention
is that my macro will process a list of files and for each input file will
write an output file in the same user selected folder. A standard dialog
would hopefully give the user the option to create a new folder for the
outputs if it doesn't already exist.

Grateful for advice.