[CLOSED] Excel: Set Print Area (without using templates)
Does anyone have a technique for being able to set a specified print area for excel (across multiple tabs) from the fex side? The user does NOT want to use a template for various reasons. Does anyone know of a way that this can be done without a template/macro?
We are using WF release 7.6.9 on a AIX platform.
Thanks for any help,
Debbie / FidelityThis message has been edited. Last edited by: Kerry,
As an example of a VB Script, the following sets the print area and then sets up the print options in Excel to fit the output on a single page in landscape print format.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
February 19, 2010, 12:35 PM
Deborah Sullivan
Thanks very much for the response. I suspected that this was the case, but wanted to explore all avenues.