View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Richard Ward[_2_] Richard Ward[_2_] is offline
external usenet poster
 
Posts: 6
Default run macro then print the results as pdf file changing the name eac

I have a workbook with multiple pivot tables/charts, I have several macros
changing the field data in these pivot tables, I want to print after each
macro is run. Each print will be to a pdf file and the name (and possibly
location) of the printed file will change.