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
|