Count all page breaks
 

msgbox application.ExecuteExcel4Macro("Get.Document(50)")

--
Regards,
Tom Ogilvy

"quartz" wrote in message
...
Using VBA in XL XP I am trying to determine whether each sheet, when
printed,
will be one or two pages.

A print area is set on each sheet. No hard page breaks are set.

Sometimes the print area extends beyond one page and so a soft page break
occurs. The second page may be blank or it may not.

I need a function that will tell me how many pages will be printed. DO NOT
tell me to use: ActiveSheet.HPageBreaks.Count as this DOES NOT WORK since
it
doesn't tell you if there is a partial second page or not within the print
area.

Please help this frustrated soul. Thanks much in advance.

Count all page breaks
 

http://office.microsoft.com/downloads/2000/Xlmacro.aspx

http://support.microsoft.com/default...85&Product=xlw
Macrofun.exe File Available on Online Services
xl97 (old winhelp format)

http://support.microsoft.com/default...66&Product=xlw
XL97: Macro97.exe File Available on Online Services
xl97 (old winhelp format)

The help file for the xl4 macro language.

The first one is in the .CHM format (internet explore) for xl2000 and later.
The next two are in the old windows help format.

--
Regards,
Tom Ogilvy

"quartz" wrote in message
...
Thanks Tom. Where can I get a list of the "Get.Document(#)" arguments and
their meaning?

"Tom Ogilvy" wrote:

msgbox application.ExecuteExcel4Macro("Get.Document(50)")

--
Regards,
Tom Ogilvy

"quartz" wrote in message
...
Using VBA in XL XP I am trying to determine whether each sheet, when
printed,
will be one or two pages.

A print area is set on each sheet. No hard page breaks are set.

Sometimes the print area extends beyond one page and so a soft page
break
occurs. The second page may be blank or it may not.

I need a function that will tell me how many pages will be printed. DO
NOT
tell me to use: ActiveSheet.HPageBreaks.Count as this DOES NOT WORK
since
it
doesn't tell you if there is a partial second page or not within the
print
area.

Please help this frustrated soul. Thanks much in advance.

Count all page breaks
 

Hi, Tom:

For your first suggestion, have they updated this EXE file so it will install
under Excel XP and/or Excel 2003? When I tried a year or so ago, it required
XL2000 to be installed. I finally got the folks in the MVP section to persuade
the development team to send me a copy of the embedded CHM file.

Myrna Larson


On Thu, 9 Sep 2004 16:44:54 -0400, "Tom Ogilvy" wrote:

http://office.microsoft.com/downloads/2000/Xlmacro.aspx

http://support.microsoft.com/default...85&Product=xlw
Macrofun.exe File Available on Online Services
xl97 (old winhelp format)

http://support.microsoft.com/default...66&Product=xlw
XL97: Macro97.exe File Available on Online Services
xl97 (old winhelp format)

The help file for the xl4 macro language.

The first one is in the .CHM format (internet explore) for xl2000 and later.
The next two are in the old windows help format.

Count all page breaks
 

I haven't test it, so I can't say. I usually use the ones from Excel 97.

--
Regards,
Tom Ogilvy



"Myrna Larson" wrote in message
...
Hi, Tom:

For your first suggestion, have they updated this EXE file so it will
install
under Excel XP and/or Excel 2003? When I tried a year or so ago, it
required
XL2000 to be installed. I finally got the folks in the MVP section to
persuade
the development team to send me a copy of the embedded CHM file.

Myrna Larson


On Thu, 9 Sep 2004 16:44:54 -0400, "Tom Ogilvy" wrote:

http://office.microsoft.com/downloads/2000/Xlmacro.aspx


http://support.microsoft.com/default...85&Product=xlw
Macrofun.exe File Available on Online Services
xl97 (old winhelp format)


http://support.microsoft.com/default...66&Product=xlw
XL97: Macro97.exe File Available on Online Services
xl97 (old winhelp format)

The help file for the xl4 macro language.

The first one is in the .CHM format (internet explore) for xl2000 and
later.
The next two are in the old windows help format.