How to insert Excel Worksheet Name using Automation in VB Dot Net??
"Herfried K. Wagner [MVP]" wrote in message ... Hello, "Vanessa" 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 |
How to insert Excel Worksheet Name using Automation in VB Dot Net??
Hello,
"Vanessa" wrote: [Nothing new] ??? Regards, Herfried K. Wagner -- MVP · VB Classic, VB .NET http://www.mvps.org/dotnet |
How to insert Excel Worksheet Name using Automation in VB Dot Net??
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" wrote in message ... "Herfried K. Wagner [MVP]" wrote in message ... Hello, "Vanessa" 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 |
All times are GMT +1. The time now is 03:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com