473,497 Members | 2,166 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

creating Excel sheets "on the fly" -- trouble with vpagebreak

To All:

I am a newbie to VB.net and am writing an application in VB.net in which I
successfully create an Excel sheet, tabulate and format some data on a sheet
titled "summarySheet".

A difficulty arises when I try to define where a page break should be. I
need to fit a landscape table on one sheet. I thought that "telling" Excel
where the vertical page break is would cause it to reduce the zoom factor,
thus fitting the table on one page. The vertical page break appears to have
been ignored.

The following bit of code shows how the pertinent object are defined.

Any ideas?

Thanks,
Ron

'-------------------------
Dim exc As New Excel.Application()
Dim summarySheet As Excel.Worksheet

summarySheet.ResetAllPageBreaks()
summarySheet.VPageBreaks.Add(exc.Range("J8"))
'-------------------------
Nov 20 '05 #1
0 1281

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

20
11636
by: Chris Krasnichuk | last post by:
hello, Does anyone know how I make php work on "my" computer? I made a mistake in my last post so I fixed it here. Chris
6
6090
by: owen | last post by:
Generally speaking, what does it mean when I see a "button" with red text showing this message instead of the control I've dragged onto the web form in Design View.? (But the page works fine at...
11
4163
by: Paul D.Smith | last post by:
Can Python create a variable "on-the-fly". For example I would like something like... make_variable('OSCAR', 'the grouch'); print OSCAR; ....to output... the grouch
4
2270
by: bibsoconner | last post by:
Hi, I hope someone can please help me. I'm having a lot of trouble with schema files in .NET. I have produced a very simple example that uses "include" to include other schema files. It all...
2
2861
by: George Marsaglia | last post by:
I have a set of, say, 2000 points in the 8-dimensional simplex S={(x_1,x_2,...,x_8),x_1+x_2+...+x_8=1, x's>=0}. To help analyze that 8-dimensional set, I wish to project the set of points onto...
2
7626
by: Lenonardo | last post by:
Hi. I'm writing a VB.Net application to update multiple Excel Worksheets. I'm using late binding (i.e. all variables are objects + use createobject) I develop the application on an XP...
3
1874
by: gregory_may | last post by:
According to this article, I cant change "CanStop" on the fly!!! ...
2
1661
by: Chuck Anderson | last post by:
I have a web page/script that displays image files residing on disk. I do not know what size they are (in pixels), so I want to be able to resize an image if it is bigger than the limit I allow...
6
2394
by: OAM | last post by:
Hi Is it possible to add and remove tabs "on the fly" ? Anybody have a (ajax...) script to do this ? Thanks Olivier.
0
7120
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
6991
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7160
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7196
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
6878
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
5456
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
4897
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
3078
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
649
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.