View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
johan johan is offline
external usenet poster
 
Posts: 34
Default Print as pdf and save as xls with filename from a datafield

Hello,

Can somebody help me out with below 2 questions.

I like to have a macro which shows me a printpreview as pdf file
(acrobat) with the filename xxxx.pdf as registered in field A2.

I like to have a macro which shows me the save as xls-file screen
where the file name xxxx.xls is as registered in field A2.

regards and thanks,
Johan