View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Doug Glancy Doug Glancy is offline
external usenet poster
 
Posts: 770
Default msoFileDialogFilePicker Question

ebferro,

You can use msoFileDialogSaveAs to do this. Be aware that it has the same
effect as doing a Save As from the file menu, i.e., you'll now be working
within the newly saved file and the next time you save it you'll be saving
to the new directory.

hth,

Doug Glancy

"ebferro" wrote in message
...
Is it possible to use the msoFileDialogFilePicker to allow a user to

navigate
to a specific folder of their choice and then input the name of a new file

to
be stored in that folder? Or, does it only work with existing files?
TIA