Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Excel: Set Print Area (without using templates)
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Excel: Set Print Area (without using templates)
 Login/Join
 
Gold member
posted
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 / Fidelity

This message has been edited. Last edited by: Kerry,
 
Posts: 52 | Location: Merrimack, NH | Registered: August 17, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
This cannot be done without a macro or template.

This article discusses how to do it with a macro: Developer Center > Tips and Techniques > Creating Excel Macros

quote:
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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
Gold member
posted Hide Post
Thanks very much for the response. I suspected that this was the case, but wanted to explore all avenues.

Thanks again,

Debbie / Fidelity
 
Posts: 52 | Location: Merrimack, NH | Registered: August 17, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Excel: Set Print Area (without using templates)

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.