setting the Left or Right HeaderPicture
Marks,
According to the VBA Help:
<Quote
With ActiveSheet.PageSetup.LeftHeaderPicture
.FileName = "C:\Sample.jpg"
......... etc
' Enable the image to show up in the left header.
ActiveSheet.PageSetup.LeftHeader = "&G"
End Sub
Note It is required that "&G" is a part of the LeftHeader property string
in order for the image to show up in the left header.
</Quote
NickHK
"mark_newbs" wrote in message
...
Hi,
I am working in c# and I am trying to set the HeaderImage of a worksheet.
I
have tried several methods:
Excel.PageSetup pageSetup =
(Excel.PageSetup)xlSheet.PageSetup;
pageSetup.LeftHeaderPicture.Filename = @"C:\image.gif";
as well as:
Bitmap bitmap = new ");
pageSetup.LeftHeaderPicture = bitmap;
neither of these seem to work.
There is very little documentation on this feature, can anyone help?
Cheers
Mark
|