I've got a template that I am trying to use for multiple reports. Depending on which macro gets run, I want it to put a string into the header so I know which report is generated. Here are the issues that I'm having:
1. I use a picture in the center space of the header and eventhough I want my Report type text to be displayed in the middle of the page, I can't get the text to run ontop of the picture unless it is in the left header field.
2. Since I have to use the left header field, I need to add spaces to the Header to Kick the Text into the center-ish place on the report, but VBA is not liking my " " designation.
3. Finally, the code below works (minus the spacing being done correctly), however I can't get VBA to pass the variable into the header. Therefore, the code below just puts "HeaderName" into the header instead of "Annual Report"
'start header
Dim HeaderName As String
HeaderName = "Annual Report"
With ActiveSheet.PageSetup
.DifferentFirstPageHeaderFooter = False
.LeftHeader = "&""Arial,Bold""&11 & "" "" & HeaderName &G"
End With
Any ideas?
Bookmarks