Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Classic ASP Professional For advanced coder questions in ASP 3. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Professional section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 13th, 2004, 11:05 AM
Registered User
 
Join Date: Apr 2004
Location: , , .
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default Page Breaks and Font Style in Excel

Hi!

I have 2 questions:

1. How can i use ASP-code to generate page breaks in Excel?
2. And what is the code for changing the font style?

Have a nice day!

Sigbjorn ;)

 
Old December 13th, 2004, 04:49 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: High Wycombe, UK, United Kingdom.
Posts: 344
Thanks: 0
Thanked 1 Time in 1 Post
Default

check out http://www.greggriffiths.org/webdev/both/excel/
 
Old December 14th, 2004, 10:30 AM
Registered User
 
Join Date: Apr 2004
Location: , , .
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I think I will try this on:

MyExcel.Rows(range).Select
MyExcel.ActiveWindow.SelectedSheets.HPageBreaks.Ad d Before:=ActiveCell

Sigbjorn





Similar Threads
Thread Thread Starter Forum Replies Last Post
Change treeview node font-style programmatically panuvin C# 2005 2 December 15th, 2007 02:59 AM
export to Excel and Page breaks sifuuu Crystal Reports 0 March 21st, 2007 06:42 AM
Page breaks rupen HTML Code Clinic 1 October 4th, 2006 04:08 PM
Different Font Style For Elements in Drop Down Box kunal_kishan HTML Code Clinic 1 July 11th, 2006 09:01 AM
ANYONE: Page Break in Excel / Font Style shagaset Classic ASP Basics 4 December 20th, 2004 01:09 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.