Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
885
ExcelExporter and Print Headers
posted

I see that I can use

e.CurrentWorksheet.PrintOptions.Header = My.Settings.EventName + vbTab + My.Settings.EntryListTitle + vbTab + DateTime.Now.ToString("yyyy-M-d")

to set a print header on a worksheet.

Excel, however, appears to offer multiple header locations

With ActiveSheet.PageSetup

        .LeftHeader = ""
        .CenterHeader = "Page Title"
        .RightHeader = ""
        .LeftFooter = "Footer Left"
        .CenterFooter = ""
        .RightFooter = "Page &P Of &N"

End With

Can these be set when exporting to Excel from an UltraWinGrid? (and I hope I don't have to open Application.Excel and do it)

Thanks in advance ...

Parents Reply Children
No Data