Setting up Filepath as a Footer in Excel 2000

Gambler

I have used an invaluable formula in Excel for many years which is the cell("filename") formula which prints the full path, filename and worksheet of the spreadsheet.

Just been speaking with a friend who has the 2003 edition and he informs me it is possible to do this as a footer in the custom footer tab.

This is not possible in 2000 but I have tried a macro I found here:

http://techrepublic.com.com/5100-1035_11-1058172.html#

Works a treat apart from one thing. It does print the path and filename but not the worksheet. The full route is important due to the complex spreadsheets that we use.

Can anybody help please?

Chippy_Minton

I don't have Excel 2000, but just changing the code to:

Worksheet.PageSetup.LeftFooter = ActiveWorkbook.FullName + " " + ActiveSheet.Name

should work.

Gambler

Chippy_Minton wrote:

I don't have Excel 2000, but just changing the code to:

Worksheet.PageSetup.LeftFooter = ActiveWorkbook.FullName + " " + ActiveSheet.Name

should work.

thanks but it's a runtime error '424' object required I'm afraid.

Chippy_Minton

Try:

ActiveSheet.PageSetup.LeftFooter = ActiveWorkbook.FullName + " " + ActiveSheet.Name

Gambler

Chippy_Minton wrote:

Try:

ActiveSheet.PageSetup.LeftFooter = ActiveWorkbook.FullName + " " + ActiveSheet.Name

star man, thank you !

I do keep asking my boss to let me go on a VB course.

Chippy_Minton

You really want a course on Visual Basic for Applications (VBA). VBA is a version of Visual Basic integrated into Microsoft Office applications with direct access to the objects of the host application. A good way to learn VBA is to play around with the Macro recorder and look at the code it produces.