Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
File Path in Excel 97
- Thread starter drm184
- Start date
=cell("filename"
Fle must be saved and updated (F9) before anything shows up. Brainbench MVP for Microsoft Word
techsupportgirl@home.com
Fle must be saved and updated (F9) before anything shows up. Brainbench MVP for Microsoft Word
techsupportgirl@home.com
This code example puts the file path and name in the left header ... substitute center, right, and footer where applicable.
sub your_file_path()
With ActiveSheet.PageSetup
.LeftHeader = ActiveWorkbook.Path + "\" + ActiveWorkbook.Name
End With
end sub
sub your_file_path()
With ActiveSheet.PageSetup
.LeftHeader = ActiveWorkbook.Path + "\" + ActiveWorkbook.Name
End With
end sub
- Status
