Is there away of getting the &[page] and &[pages] data into a cell, and will
it work when printing?
Unfortunately, there is no easy way to use that and put the information you
want in a cell in that range.
you would either need to create a separate worksheet that lays out the data
exactly as you want it printed with the 3 rows of information physically
repeated in each "page" with the hardcoded page and pages information
entered in the cell. Or you would have to print each page separately using
rows to repeat at the top, but before each page printed, entering the page
and pages information in the cell. In the second case, you would have to
calculate the pages information and you could keep track of the page
information. In the first case, you would of course know this information.
Then again, someone may have a better approach I am not aware of.
--
Regards,
Tom Ogilvy
"Steve J. Vaughan" <SteveJ...@discussions.microsoft.com> wrote in
message news:AB416BA3-575F-4C76...@microsoft.com...
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Steve J Vaughan" <Steve J Vau...@discussions.microsoft.com> wrote in
message news:04EA4E23-0635-4247...@microsoft.com...
It would work if the OP did a physical layout, but then he could just hard
code in the page number since it is already known.
While a clever idea, I have a hard time seeing where it would actually have
any application. I assume there are some special cases since Frank said he
is often asked.
--
Regards,
Tom Ogilvy
"Ron de Bruin" <ronde...@kabelfoon.nl> wrote in message
news:O728zWn8...@TK2MSFTNGP11.phx.gbl...
That does what I need with the exception that I need to have the cell in one
of the three rows which is then repeated at the top of each page. A little VB
is not a problem as long as it is not too heavy.
Nice solution though.
> While a clever idea, I have a hard time seeing where it would actually
> have
> any application.
me to
I only add it to this thread as information.
But this one I use regular
Dim TotPages As Long
TotPages = Application.ExecuteExcel4Macro("GET.DOCUMENT(50)")
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Tom Ogilvy" <twog...@msn.com> wrote in message
news:%23P4rjqn...@TK2MSFTNGP14.phx.gbl...
--
Regards
Frank Kabel
Frankfurt, Germany
"Tom Ogilvy" <twog...@msn.com> schrieb im Newsbeitrag
news:%23P4rjqn...@TK2MSFTNGP14.phx.gbl...
I'm not sure if you mean "Sheets" or "Pages". If Pages I don't see how these
details only in the top row help unless each sheet prints as one page, but I
may be missing something.
Whatever, maybe the old xl4 functions might be of use to you. Find and
download a copy of "Macrofun.hlp" or "Macrofun.zip" and look in particular
at the GET.DOCUMENT and GET.WORKBOOK functions
To use these in cell formulas they need to be defined as formulas, eg
Defined Name =formula
Total_Sheets =GET.WORKBOOK(4)
TotalPrintPages =GET.DOCUMENT(50)
PrintHeader =GET.DOCUMENT(54)
Then in a cell type "Total_Sheets" without quotes
It might be possible to return current sheet as a number.
Regards,
Peter T
"Steve J. Vaughan" <SteveJ...@discussions.microsoft.com> wrote in
message news:AB416BA3-575F-4C76...@microsoft.com...
I guess I was not seeing a need to dynamically determine a page number (I
have never been criticised for having too much imagination, however). It is
useful on a fixed layout that will not change - but if it won't change, then
one knows the page number although it might be convenient to have a formula
do it. If the layout will change, then I don't see the need to have a page
number appear at some unknown location on the page - maybe useful for a
filter situation. It wasn't meant to be a criticism in anyway because as I
said, it is very innovative.
My real purpose in posting was to alert the OP that I didn't think it would
solve his problem and save time he might spend thinking it might. Then
again, it might fit somehow.
--
Regards,
Tom Ogilvy
"Frank Kabel" <frank...@freenet.de> wrote in message
news:ujdHDEo8...@tk2msftngp13.phx.gbl...
--
Regards,
Tom Ogilvy
"Steve J Vaughan" <SteveJ...@discussions.microsoft.com> wrote in message
news:DA3CD443-B67B-4BCE...@microsoft.com...
> I guess I was not seeing a need to dynamically determine a page number (I
> have never been criticised for having too much imagination, however). It
> is
> useful on a fixed layout that will not change - but if it won't change,
> then
> one knows the page number although it might be convenient to have a
> formula
> do it. If the layout will change, then I don't see the need to have a
> page
> number appear at some unknown location on the page - maybe useful for a
> filter situation. It wasn't meant to be a criticism in anyway because as
> I
> said, it is very innovative.
Also didn't considered your initial posting as criticism!.
Though a little bit OT: I think Excel's current features for customized
headers/footers are just poor. For dynamic headers you need VBA. And if you
want to resort to headers directly on your sheet you have problems getting
the page numbering information.
On the other hand maybe if you have this kind of reporting requirements one
should not use Excel anyway :-)
> My real purpose in posting was to alert the OP that I didn't think it
> would
> solve his problem and save time he might spend thinking it might. Then
> again, it might fit somehow.
And only the OP will know :-)
Maybe he posts back!
Regards
Frank Kabel
He did
> That does what I need but . . .
>A little VB
>is not a problem as long as it is not too heavy.
Last time I checked, working with pagebreaks in VB is very heavy.
--
Regards,
Tom Ogilvy
"Frank Kabel" <frank...@freenet.de> wrote in message
news:%23glgnIp...@TK2MSFTNGP12.phx.gbl...
--
Regards
Frank Kabel
Frankfurt, Germany
"Tom Ogilvy" <twog...@msn.com> schrieb im Newsbeitrag
news:%235OdZTp...@TK2MSFTNGP09.phx.gbl...