View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stratuser[_2_] Stratuser[_2_] is offline
external usenet poster
 
Posts: 4
Default Using Dialogs Save

When I write the following code my macro goes to the
subdirectory specified in the Inputsub range to open
files, with no problem:

Application.Dialogs(xlDialogOpen) Range("Inputsub").Value

BUT, the following code does NOT cause my macro to go the
same subdirectory to save files:

Application.Dialogs(xlDialogSaveWorkbook) Range
("Inputsub").Value

I want to import and export to this same Inputsub
location. Any ideas?