View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mr Cockles Mr Cockles is offline
external usenet poster
 
Posts: 1
Default Print to pdf and save without prompts

I have a macro which takes a selection of each page in a workbook. (specific
to each page) This is then printed to pdf and at the moment I have to save
each filename as I go along. Which is obviously time consuming. Is there a
way of naming these without a prompt coming up automatically and saving it in
a new folder in a given location?

Cheers in advance

Jeff