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