Image file within Excel Header or footer

[Zaichik123]

Unless I am mistaken it is impossible to select an image file (like a company logo) to be added to your header or footer through File/Page setup... (Microsoft Office 2000 Pro)
But I'm sure it must be able to be done through VB, I've been playing around with some code for a hour or so now and I'm sure I'm on the brink of cracking it - can anyone confirm it is definitely possible and save my poor brain before it turns to mush! (if you have the code and could include in your response, I'd be very grateful)

I was initially thinking:
With ActiveSheet.Pagesetup
.RightHeader = ChDir "file location"
Workbooks.Open Filename:= _
"file location"
Range(" &quot.Select
ActiveSheet.Shapes("Object 1&quot.Select
Selection.Copy
ActiveWindow.Close
Range(" &quot.Select
ActiveSheet.Paste

 

[Chattin]

I have a workaround example on my work PC so if you e-mail me at chrisjchattin@yahoo.co.uk so I can have your address I'll send you the workbook tomorrow

HTH

 

[Chattin]

OMG - what a day. Sorry to say I've lost the file as my work PC's HD died. A lot of my stuff I'd backed up onto the network but unfortunately this file was one of the casualties - if I manage to get it back I'll let you know. v. embarassing to let you down - again sorry

 

[Zaichik123]

Thanks anyway.

 

[Chattin]

Haven't been able to retrieve the file unfortunately but here are a couple of links you might find handy

http://www.mrexcel.com/board2/viewtopic.php?t=61372&highlight=image+header

http://support.microsoft.com/default.aspx?scid=kb;en-us;268071

HTH