#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,123
Default Total of pages

Hi Rodrigo

You can try

Sub test()
Dim TotPages As Long
TotPages = Application.ExecuteExcel4Macro("GET.DOCUMENT(50)")
MsgBox TotPages
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Rodrigo Ferreira" wrote in message ...
How can I get total of pages (before print) using macro?

--

Rodrigo Ferreira




  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 79
Default Total of pages

How can I get total of pages (before print) using macro?

--

Rodrigo Ferreira


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivots - Auto calc % Sub total is of grand total VBA Noob Excel Discussion (Misc queries) 3 August 8th 06 08:46 PM
Pivot Table Sub total and totals Karen53 Excel Worksheet Functions 4 July 23rd 06 07:04 PM
sum of total hours not correct Bruno Lauwers Setting up and Configuration of Excel 9 September 6th 05 08:03 AM
Total Across Pages MamaHart New Users to Excel 2 May 12th 05 03:35 PM
how do I merge total from many pages into one main page in excel? JER Excel Discussion (Misc queries) 1 May 6th 05 03:29 PM


All times are GMT +1. The time now is 07:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"