Vanessa,
This code will put "Page #" in the right footer and the sheet tab name in
the center footer
With ActiveSheet.PageSetup
.LeftFooter = "Page & &P"
.CenterFooter = "&A"
End With
You can use the macro Recorder to get other code. But beware that the code
I got for PageSetup was 32 lines and I had to edit it down to 4 lines. This
edit is especially important in this case since PageSetup is a very slow
procedure and bogs down your code.
The other way is to just manually go into PageSetup and set it up.
--
sb
"Vanessa" <va*****@eclinic.com.sg> wrote in message
news:ek**************@TK2MSFTNGP09.phx.gbl...
"Herfried K. Wagner [MVP]" <hi*******@m.activevb.de> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl... Hello,
"Vanessa" <va*****@eclinic.com.sg> schrieb: In my VB Dot Net program, I'm using Automation to call
Excel worksheet to do some insert some data.
I have rename my worksheet to a name. eg. "ABC".
How do I insert the worksheet name & Page No to the
Footer so that when I print the worksheet, the name of
the worksheet and page number will be
printed out as well?
I think the Excel programmers can help you:
news://news.microsoft.com/microsoft....el.programming
Regards,
Herfried K. Wagner
--
MVP · VB Classic, VB .NET
http://www.mvps.org/dotnet
