View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
VBA Noob VBA Noob is offline
external usenet poster
 
Posts: 26
Default 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