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.