We have a requirement to run a templated output for a WebFocus report that include the capability to have the output ready to print. In other words, a user should be able to see the exact printout available when the Excel opens by clicking on "Print Preview".
Issues: 1.) The output can be anyway from 50 to several thousand lines (usually in the 300 - 600 line length. 2.) At the end of the report there are several lines of legalese that are actually situated in the B column but appear spread over seven or eight columns. 3.) There are 20 lines at the top that should appear on the top of each page. Currently these lines are set up with the Page Setup function. 4.) The report should appear in 65% and can be either portrait or landscape. Thanks in advance. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
