software

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

amp;[File] however when I tried the same theory for the folder and used
amp;[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: www.excelforum.com/member.php...oamp;userid=28738
View this thread: www.excelforum.com/showthread...hreadid=501018There are buttons that you can click to get those fields.

In xl2002 , there's a button that looks like a folder that shows:
amp;[Path]
when you click on it.

Before xl2002, you'll need some other solution.

Maybe John Walkenbach's addin:
j-walk.com/ss/excel/files/addpath.htm
to add the path in the header/footer

weeclaire wrote:
gt;
gt; Hi All
gt;
gt; Hoping someone will be able to help me with this query. I am trying to
gt; create a customised footer on a number of excel workbooks. The problem
gt; I have is that the final folder and the file name will change on a
gt; monthly basis. Other than that the path remains the same. I do not
gt; want to have to remember to change the folder and file in the footer on
gt; a monthly basis and was hoping there was a way to create a footer and
gt; allow for this change. I know that it is possible to do the file using
gt;
gt; amp;[File] however when I tried the same theory for the folder and used
gt; amp;[Folder] these words actually appeared on the footer.
gt;
gt; Help! I'm sure there is a way to do this and it is driving me insane
gt; trying to find it.
gt;
gt; Thanks
gt;
gt; Claire
gt;
gt; --
gt; weeclaire
gt; ------------------------------------------------------------------------
gt; weeclaire's Profile: www.excelforum.com/member.php...oamp;userid=28738
gt; View this thread: www.excelforum.com/showthread...hreadid=501018

--

Dave Peterson


I'm using Xl2000 so the hunt continues.

Regards

Claire--
weeclaire
------------------------------------------------------------------------
weeclaire's Profile: www.excelforum.com/member.php...oamp;userid=28738
View this thread: www.excelforum.com/showthread...hreadid=501018Hi Claire

Try adding the following macro to a button on your toolbar.
Viewgt;Toolbarsgt;Customisegt;slide down Categories till you get to Macrogt;drag
the Custom macro button to your toolbar.
Whilst Customise dialogue box is still open, then right click on new
icongt;Add macrogt; footerpath

Sub footerpath()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Sheets
ws.Activate
ws.PageSetup.RightFooter = quot;quot;
ws.PageSetup.RightFooter = ActiveWorkbook.FullName
Next
End Sub

To copy the macro footerpath code as shown above then
Alt F11 (open Visual Basic Editor)
Ctrl R (open Project Explorer)
Select your workbook name on left
If no modules exist:
Insert gt; Module
Paste code in Module
If modules exist:
Double click desired module
Paste code in Module
Clicking the newly added button in your file, will remove anything
entered in your right footer of each worksheet, and will add the current
path and name of file.
Change .rightfooter to .leftfooter or .centerfooter as required.--
Regards

Roger Govierquot;weeclairequot; gt;
wrote in message
...
gt;
gt; I'm using Xl2000 so the hunt continues.
gt;
gt; Regards
gt;
gt; Claire
gt;
gt;
gt; --
gt; weeclaire
gt; ------------------------------------------------------------------------
gt; weeclaire's Profile:
gt; www.excelforum.com/member.php...oamp;userid=28738
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=501018
gt;
You could write your own code or use an addin that writes the code for you.

Take a look at that addin from John Walkenbach.

weeclaire wrote:
gt;
gt; I'm using Xl2000 so the hunt continues.
gt;
gt; Regards
gt;
gt; Claire
gt;
gt; --
gt; weeclaire
gt; ------------------------------------------------------------------------
gt; weeclaire's Profile: www.excelforum.com/member.php...oamp;userid=28738
gt; View this thread: www.excelforum.com/showthread...hreadid=501018

--

Dave Peterson