&G in Footer
 

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.

&G in Footer
 

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

In article ,
"Steve" wrote:

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?

&G in Footer
 

Steve

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


Gord Dibben MS Excel MVP

On Tue, 15 May 2007 11:14:59 -0400, "Steve"
wrote:

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.

&G in Footer
 

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"


Gord Dibben wrote:

Steve

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

Gord Dibben MS Excel MVP

On Tue, 15 May 2007 11:14:59 -0400, "Steve"
wrote:

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.


--

Dave Peterson

&G in Footer
 

Thanks to all.



"Dave Peterson" wrote in message
...
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"


Gord Dibben wrote:

Steve

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

Gord Dibben MS Excel MVP

On Tue, 15 May 2007 11:14:59 -0400, "Steve"

wrote:

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.


--

Dave Peterson

&G in Footer
 

Thanks Dave


Gord

On Tue, 15 May 2007 12:14:10 -0500, Dave Peterson
wrote:

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"


Gord Dibben wrote:

Steve

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

Gord Dibben MS Excel MVP

On Tue, 15 May 2007 11:14:59 -0400, "Steve"
wrote:

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.