ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Is there an update to this? (https://www.excelbanter.com/excel-programming/309190-there-update.html)

Jim May

Is there an update to this?
 
I've noted the following random code line:
Totalpage = Application.ExecuteExcel4Macro("GET.DOCUMENT(50)")

This looks quite "old" with it's reference to Excel4;
Is there an update or new way of performing the same feat?
TIA,



Tom Ogilvy

Is there an update to this?
 
Unfortunately,
the alternative is to loop through the pagebreaks and figure it out on your
own.

--
Regards,
Tom Ogilvy

"Jim May" wrote in message
news:EUh%c.43141$wu.10919@okepread04...
I've noted the following random code line:
Totalpage = Application.ExecuteExcel4Macro("GET.DOCUMENT(50)")

This looks quite "old" with it's reference to Excel4;
Is there an update or new way of performing the same feat?
TIA,






All times are GMT +1. The time now is 03:49 AM.

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