Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 area. Please help this frustrated soul. Thanks much in advance. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vertical page breaks won't drag in Page Break Preview | Excel Discussion (Misc queries) | |||
How do I do page breaks when view menu doesnt page break preview | Excel Discussion (Misc queries) | |||
Page Breaks- Printing selected rows on same page | Excel Discussion (Misc queries) | |||
Count number of manual and automatic vertical page breaks - examples | Excel Programming | |||
Count the number of just the horizontal manual page breaks | Excel Programming |