ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel Page count (https://www.excelbanter.com/excel-programming/271900-re-excel-page-count.html)

Tom Ogilvy

Excel Page count
 
numPages = Application.ExecuteExcel4macro("Get.Document(50)")

Regards,
Tom Ogilvy



"Joe" wrote in message
...
Would anybody have some example code that shows count the
number of pages that are shown in the page break preview
in Excel? I am trying to get page counts from different
office files by looping thru a column in Excel that
contains file names. When I find an Excel file, I want to
count the number of pages that will be displayed in the
page break preview view.


Thanks

Joe.





All times are GMT +1. The time now is 11:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com