ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Using Dialogs Save (https://www.excelbanter.com/excel-programming/272367-using-dialogs-save.html)

Stratuser[_2_]

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?


All times are GMT +1. The time now is 04:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com