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