View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Set "Print entire Workbook" property from interop code

Oliver,
According to VBA help on "Built-In Dialog Box Argument Lists":
"xlDialogPrint
range_num, from, to, copies, draft, preview, print_what, color, feed,
quality, y_resolution, selection, printer_text, print_to_file, collate"

I would guess "print_what" is what you need, but I have no idea what value
is expected.
Some experimentation is required.

NickHK

"Oliver" wrote in message
...
Hi Everyone,

is it possible to set the "Print entire Workbook" property from code ? I
haven't found a way so far.

Can anyone help me on this ?

thanks,
Oliver