Software

Ask something
Discussion Locked

Automate Path, File and Tab Names

0 helpful
2 replies

by stuarts

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I would like to know how to automate the Path Name, File Name and Tab name in each Excel book that I use. I'm assuming that it would be done in the Header / Footer section as there is a button for File name and Tab name but nothing for the path. Does anyone know how to do this?

2 replies

by dklippert

It's available in 2002 +
&[Path]&[File]&[Tab]

The function for the path, filename and tab is:

=Cell("filename",A1)

by stuarts

What about in Excel 2000? In Excel 2000, the &[Path] doesn't seem to work. The &[File] &[Tab] does work. Any further ideas?

This discussion is closed to new replies.