How to change font in a macro that inserts a formula in a footer

[Guest]

I've written the following macro (this is the operative part of it) to insert
the file name AND path into the left footer of my Excel 2000 spreadsheet:

With ActiveSheet.PageSetup
.LeftFooter = ActiveWorkbook.Path
.LeftFooter = ActiveWorkbook.FullName
End With

The macro works fine. HOWEVER, I want to change the point size of the font
from "normal" to .08. I've tried entering a line code of "&08", but it
doesn't work, as this is intended to change text. Since the macro is
entering a formula, the "&08" doesn't work.

Any solution?

Thank you in advance.

 

[Tom Ogilvy]

With ActiveSheet.PageSetup
.LeftFooter = "&8" & ActiveWorkbook.FullName
End With

 

[Guest]

Thank you!

@

With ActiveSheet.PageSetup
.LeftFooter = "&8" & ActiveWorkbook.FullName
End With