Hi All

Hoping someone will be able to help me with this query. I am trying to
create a customised footer on a number of excel workbooks. The problem
I have is that the final folder and the file name will change on a
monthly basis. Other than that the path remains the same. I do not
want to have to remember to change the folder and file in the footer on
a monthly basis and was hoping there was a way to create a footer and
allow for this change. I know that it is possible to do the file using

&[File] however when I tried the same theory for the folder and used
&[Folder] these words actually appeared on the footer.

Help! I'm sure there is a way to do this and it is driving me insane
trying to find it.

Thanks

Claire


--
weeclaire
------------------------------------------------------------------------
weeclaire's Profile: http://www.excelforum.com/member.php...o&userid=28738
View this thread: http://www.excelforum.com/showthread...hreadid=501018