I am having a problem with the delopment of some code to construct a footer.
By creating a macro I got the following:

ActiveSheet.PageSetup.PrintArea = ""
With ActiveSheet.PageSetup
.LeftFooter = "&""Times New Roman,Regular""&8Path String&F"
End With

I am trying to construct a footer string on the fly, concatenating the font
formatting ("&""Times New Roman,Regular""&8), the Path String and the auto
file name (&F")

I tried several things including assigning the entire string to a variable
causing Excel to ignore the control (&) characters as well as assigning the
string components to several variables causing Excel's VBA engine to cough up
a hairball. Any ideas?
--
Sierk