Using Dialogs Save

S

Stratuser

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing multiple sheets 2
Open a text file using a dialog box 2
Macro to import multiple sheets 2
Excel 2003 - Save as dialog box 1
Dialog Box 2
Workbooks.Open using Dialog box 1
change local drive / folder to network folder 3
Macro stops running if date is not in past... 3

Top