LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Excel 2003 - Determine the number of printed pages

I am creating a custom application for printing excel documents, which will
renumber a collection of files. But to be able to do this I need to be able
to determine how many pages will actually print from each document. I only
want to print the first sheet, and print it using the print area and margins
already defined.

There is a way to do it for older versions of excel:

ExecuteExcel4Macro("GET.DOCUMENT(50)")

but this does not work with Ecel 2003. I am getting incorrect data back
with that.

Again, my files may have more than one sheet and may have data outside the
print area. What i need, is to be able to determine how many pages will
print. All my page breaks are automatic, none are forced.

Any help will be GREATLY appreciated. This is my last stepping stone.
Thanks.

(Coding in C# .Net but if you have ANY help/examples please send them!)

-Morgan
 
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
How to extract the number of pages in a cell (Excel 2003) Vahid Excel Discussion (Misc queries) 2 March 26th 10 10:41 AM
number of pages will be printed Jon Excel Discussion (Misc queries) 0 November 17th 08 09:24 AM
Watermark on all printed pages in Excel Kathrine Excel Discussion (Misc queries) 5 November 28th 06 04:47 PM
Increment Date Based on Number of Pages Printed [email protected] Excel Discussion (Misc queries) 2 May 10th 06 07:03 PM
Get number of pages to be printed - before print Les Stout[_2_] Excel Programming 8 October 27th 05 05:17 PM


All times are GMT +1. The time now is 12:32 AM.

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

About Us

"It's about Microsoft Excel"