View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
magmike[_2_] magmike[_2_] is offline
external usenet poster
 
Posts: 35
Default Button to Save File as PDF

On Dec 1, 6:42*pm, isabelle wrote:
hi magmike,

fileSaveName = Application.GetSaveAsFilename(fileFilter:="PDF Files (*.pdf), *.pdf")

--
isabelle


Thank you for your help Isabell, however there are two problems with
this...

(1) The name field for the file is filled in with a suggestion based
on the file name of the workbook - is it possible for it to be blank?
(2) Once named, browsed to and then saved - the file doesn't actually
save anywhere. Where is it going? Or am I missing a command?

Thanks in advance for your help.

magmike