Add Worksheet Name To An Excel Printout. If you set excel to visible at the start of yor code, when you open your excel file via code, does Go into the macro editor and see if it has a different value for the printer name. Add Sheet Before / After Another Sheet.
Excel VBA Application Object, the Default Object in Excel. By default, the sheet is called Sheetxx, where xx represents the number of the sheet. How to: Use the WPF Chart Rendering Mechanism When Printing or Exporting a Workbook to Excel Export Library.
If you set excel to visible at the start of yor code, when you open your excel file via code, does Go into the macro editor and see if it has a different value for the printer name.
Related Links: Working with Objects in Excel VBA.
You give the sheet a new name by changing the Name property of the ActiveSheet object. How to: Print Titles on a Worksheet. My example is admittedly not itself relevant.