View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alex281 Alex281 is offline
external usenet poster
 
Posts: 2
Default need to access the xldialogprint object parameters

When a user saves a workbook, I need to record the specific print settings
for that workbook.

I am already recording the application.activeprinter as well as the
activesheet.pagesetup settings, however I need to also record the print
range, the number of copies as well as the collate settings, and the "print
what" settings from the xldialogprint object. How can I access these
settings?

Thanks,
Alex