Page Breaks and Font Style in Excel

Wrox Programmer Forums

		Wrox Programmer Forums > ASP.NET and ASP > ASP 3 Classic ASP Active Server Pages 3.0 > Classic ASP Professional
Page Breaks and Font Style in Excel

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

shagaset

shagaset is offline

Registered User

Join Date: Apr 2004

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

Greg Griffiths Greg Griffiths is offline

Greg Griffiths is offline

Friend of Wrox

Join Date: Jun 2003

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

shagaset

shagaset is offline

Registered User

Join Date: Apr 2004

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