Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to extract the number of pages in a cell (Excel 2003) | Excel Discussion (Misc queries) | |||
number of pages will be printed | Excel Discussion (Misc queries) | |||
Watermark on all printed pages in Excel | Excel Discussion (Misc queries) | |||
Increment Date Based on Number of Pages Printed | Excel Discussion (Misc queries) | |||
Get number of pages to be printed - before print | Excel Programming |