how to insert Image to Excel page header
Posted: Sat Mar 29, 2014 7:46 am
Hello everyone,
I want to insert a image to the excel page header, use the Excel's VBA macro, i found this:
I know insert a image to a Excel Cell is easy:
xlsWorkSheet.Drawing.InsertImage()
but I didn't find related property like "PageSetup.LeftHeaderPicture" in the xlsReadWriteII 5?
is this be supported in xlsReadWriteII5?
thanks in advance!
I want to insert a image to the excel page header, use the Excel's VBA macro, i found this:
Code: Select all
ActiveSheet.PageSetup.LeftHeaderPicture.Filename = "D:\SnapShot\main_logo.bmp"
Application.PrintCommunication = False
With ActiveSheet.PageSetup
.LeftHeader = "&G"
.CenterHeader = "&G"
.RightHeader = ""
.LeftFooter = ""
...
xlsWorkSheet.Drawing.InsertImage()
but I didn't find related property like "PageSetup.LeftHeaderPicture" in the xlsReadWriteII 5?
is this be supported in xlsReadWriteII5?
thanks in advance!