Including path with file name


Posted by Robert Curiale on December 02, 1999 10:44 AM

What is the command to include the path along with the
file name in the header or footer of a document?



Posted by Ivan Moala on December 02, 1999 6:01 PM

Try something like this

Sub UpDateFooter ()
ActiveSheet.PageSetup.LeftFooter = ActiveWorkbook.FullName
End Sub


Ivan