&G in Footer

[Steve]

I'm using XL 2000, and a colleague sent me a file with &G in the footer. I
don't know what version of XL she was using, nor do I know the origin of the
workbook.

Can someone explain if this has something to do with inserting a graphic in
the footer in XL 2002?

Thanks.

 

[JE McGimpsey]

Never used XL02, but in XL04 &G is the code to include a picture in the
footer.

 

[Gord Dibben]

Steve

Excel 2002 uses &[Picture]...................not &G


Gord Dibben MS Excel MVP

 

[Dave Peterson]

But if you look at the recorded code when you insert a picture, that &G rears
its ugly head:

ActiveSheet.PageSetup.LeftHeaderPicture.Filename = _
"C:\My Pictures\mypict.JPG"
With ActiveSheet.PageSetup
.PrintTitleRows = ""
.PrintTitleColumns = ""
End With
ActiveSheet.PageSetup.PrintArea = ""
With ActiveSheet.PageSetup
.LeftHeader = "&G"

Steve

Excel 2002 uses &[Picture]...................not &G

Gord Dibben MS Excel MVP

I'm using XL 2000, and a colleague sent me a file with &G in the footer. I
don't know what version of XL she was using, nor do I know the origin of the
workbook.

Can someone explain if this has something to do with inserting a graphic in
the footer in XL 2002?

Thanks.

 

[Steve]

Thanks to all.

But if you look at the recorded code when you insert a picture, that &G
rears
its ugly head:

ActiveSheet.PageSetup.LeftHeaderPicture.Filename = _
"C:\My Pictures\mypict.JPG"
With ActiveSheet.PageSetup
.PrintTitleRows = ""
.PrintTitleColumns = ""
End With
ActiveSheet.PageSetup.PrintArea = ""
With ActiveSheet.PageSetup
.LeftHeader = "&G"

Steve

Excel 2002 uses &[Picture]...................not &G

Gord Dibben MS Excel MVP

I'm using XL 2000, and a colleague sent me a file with &G in the footer.
I
don't know what version of XL she was using, nor do I know the origin of
the
workbook.

Can someone explain if this has something to do with inserting a graphic
in
the footer in XL 2002?

Thanks.

 

[Gord Dibben]

Thanks Dave


Gord

But if you look at the recorded code when you insert a picture, that &G rears
its ugly head:

ActiveSheet.PageSetup.LeftHeaderPicture.Filename = _
"C:\My Pictures\mypict.JPG"
With ActiveSheet.PageSetup
.PrintTitleRows = ""
.PrintTitleColumns = ""
End With
ActiveSheet.PageSetup.PrintArea = ""
With ActiveSheet.PageSetup
.LeftHeader = "&G"

Steve

Excel 2002 uses &[Picture]...................not &G

Gord Dibben MS Excel MVP

I'm using XL 2000, and a colleague sent me a file with &G in the footer. I
don't know what version of XL she was using, nor do I know the origin of the
workbook.

Can someone explain if this has something to do with inserting a graphic in
the footer in XL 2002?

Thanks.