| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help needed with 'Save As' dialog
hello gurus
I'm having trouble with the following code. The last line I've show works perfectly - the 'Save As' dialog comes up, and the 'File Name' drop-down box correctly shows the value of strFileName. But, I can't figure out how to get the 'Save In' drop down box to show the value of strSaveLocation. strSaveLocation = "C:\EmpData\2009" strFileName = "Report_" & strDate & "_" & strEmpName & ".xls" Application.Dialogs(xlDialogSaveAs).Show strFileName Any clues welcomed! Terry W. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Print dialog return help needed | Excel Programming | |||
| Save Excel Worksheet As CSV - No Save As Dialog | Excel Programming | |||
| how to get disk icon on save button of save as dialog like 2000 | Excel Discussion (Misc queries) | |||
| Changing Save As Type in Save as dialog box | Excel Programming | |||
Threaded Mode
