According to the VBA Help:
.FileName = "C:\Sample.jpg"
' Enable the image to show up in the left header.
ActiveSheet.PageSetup.LeftHeader = "&G"
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.