Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Running Custom Code if "Entire Workbook" is Selected for Printing rfedge Excel Programming 1 September 10th 06 06:12 AM
Interop - "Unable to set the Color property of the Interior class" Elsa Excel Programming 2 August 23rd 06 04:57 AM
Removing "Spaces" Entire Workbook carl Excel Worksheet Functions 2 June 6th 06 04:56 PM
Allocating "Don't Move or size with cells" property in code Jim McLeod Excel Programming 1 April 19th 04 10:57 AM
What are the System Tables named "Print Area" & "Print Titles"? Tom Ogilvy Excel Programming 1 August 18th 03 05:38 PM


All times are GMT +1. The time now is 12:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"