trouble with Excel and 'vpagebreak'

[Ronald Snelgrove]

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"))
'-------------------------