| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 - Save as dialog box
Hi,
Using code I would like to open the save as dialog box, change the path to which it saves and ideally change the save as type to PDF and use the ThisWorkbook.Name So far I've managed to open the dialog with the below but not sure how to do the changing the path and file ext or if even possible for 2003. Application.Dialogs(xlDialogSaveAs).Show Any help would be appreciated Danny |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save Dialog pops up now - Excel 2007 | Excel Programming | |||
| How to capture Excel Save As dialog box? | Excel Programming | |||
| Save file dialog box in Excel | Excel Discussion (Misc queries) | |||
| Save Excel Worksheet As CSV - No Save As Dialog | Excel Programming | |||
| Calling Excel File Save As Dialog | Excel Programming | |||
Threaded Mode
