Adding a path to the footnote in an excel worksheet

Can someone help me, i realise they may seem stupid or trivial to whoever knows the answer, but truth is i am stomped... I have been looking for a way to add, within the footnote of an excel worksheet the path as well as the file name of the said document... ( as can be done in word ) I simply have not found the option to do so.. is it even possible to do?

Do you mean a footer rather than a footnote? Excel to my knowledge doesn't have footnotes.
If you meant a footer use:

With ActiveSheet.PageSetup
.LeftFooter = "One"
.CenterFooter = "of"
.RightFooter = "these"
End With