Is it possible to alter Excel Viewer print settings via VB.NET and, if so, what is the syntax I need to do this?
I would like my application to be able to change the printing preferences of an Excel spreadsheet opened in Excel Viewer (through the application via
This application, when given a document name, searches a directory and opens that document in Excel Viewer (or Excel, if it's installed, but this is usually not the case) if it exists. I would like to make it as simple as possible for the client to use the software, including the Excel viewer. Often simply viewing these spreadsheets isn't adequate for the particular situation the program is being written for; the client would like to print the entire workbook. Unfortunately the default setting is to print active worksheets. When I say I would like to make printing as simple as possible for the client, I mean I would like them to be able to hit the 'Quick Print' button in the Home ribbon and have the entire workbook print off.
At the moment, the only way I can see to print the entire workbook is to press first the Microsoft Office Button, then Print --> Print, which opens the print dialog, then selecting 'Entire workbook' in the 'Print what' section. I would like to avoid this process entirely and have the application do this for the client so they can, like I've already mentioned, just hit the 'Quick Print' button.