View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default 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