Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.dotnet.general,microsoft.public.dotnet.languages.vb,microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.dotnet.general,microsoft.public.dotnet.languages.vb,microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.dotnet.general,microsoft.public.dotnet.languages.vb,microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL 2007 - INSERT NEW WORKSHEET | Excel Worksheet Functions | |||
Worksheet Automation and Size Limiting | Excel Worksheet Functions | |||
Worksheet Design for Automation | Excel Discussion (Misc queries) | |||
Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
How do I insert a clock in excel worksheet? | Excel Worksheet Functions |