Alternative to document(50)

  • Thread starter Thread starter J S
  • Start date Start date
J

J S

I need another way to count the number of pages in a worksheet then the
excel4 macro below.

ExecuteExcel4Macro("Get.document(50,"")")

Does another way exist? Some VBA method perhaps?

The reason I ask is because I have run into a strange bug. I lauch an excel
spreadsheet via a VBscript. Normally I keep excel.visible = false, so that
it runs in the background. Recently, we have been noticing incorrect
pagenumbers (Which are calculated via the document(50) function). After some
investigation I have found that document(50) is returning different numbers
depending on whether or not excel is visible(+1 is excel is hidden), even
though the spreadsheet is exactly the same otherwise!!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ExecuteExcel4Macro("GET.DOCUMENT(50)") 10
For Next with negative step ? 5
Get.document(50) 0
Import of 50+ Survey Data Results 5
Saving a Word document as PDF from en Excel macro 2
I want to take select cells from other rows (2 and 3) and combinethem with row 1 1
How to assign PRINT option to execute a macro 3
cpu at 50% 1

Back
Top