View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
isabelle isabelle is offline
external usenet poster
 
Posts: 587
Default Button to Save File as PDF

hi magmike,

VBA Help "Built In Dialog Arguments" lists the second argument of xlSaveAs as type_num
on xl2002, type_num = 1 gives .xls and there is no possibility for pdf
but on xl2007 it will be different you have to find the type_num for pdf

Application.Dialogs(xlDialogSaveAs).Show , 2 'adap type_num

'if you want to propose a file name

Application.Dialogs(xlDialogSaveAs).Show "default fileName", 2


--
isabelle