Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I insert the directory path in my Excel file?
I have Windows XP operating sys and Excel 2000 version. I am trying to
insert my directory path in my Excel document. In older versions of Excel and other operating systems, ie. Windows 2000, there is an icon in the "Header/Footer" [File Menu, Page Setup, Header/Footer tab] where you can click to add the directory whether it is on the C: drive or a shared network drive, ie. S; drive. The other 2 options are the add the file name &[File] and tab name &[Tab] in any given workbook you are in. In other versions, when you click on the icon, I beleive the command is either &[Directory] or &[Path]. But when I manually type this command in,it comes up as text, it does do the function. I have looked in the Toolsmenu, Customize, to see if I can even find the icon to add it, but it is not there either. I did find a command to enter to get the directory, =info("directory") but the problem with this is it would have to be manually entered in each workbook and if the workbook is more than one page long, it will only appear on the first page. Any ideas?? |
#2
|
|||
|
|||
See:
http://www.mcgimpsey.com/macoffice/e...llnameinfooter. html HTH Jason Atlanta, GA -----Original Message----- I have Windows XP operating sys and Excel 2000 version. I am trying to insert my directory path in my Excel document. In older versions of Excel and other operating systems, ie. Windows 2000, there is an icon in the "Header/Footer" [File Menu, Page Setup, Header/Footer tab] where you can click to add the directory whether it is on the C: drive or a shared network drive, ie. S; drive. The other 2 options are the add the file name &[File] and tab name &[Tab] in any given workbook you are in. In other versions, when you click on the icon, I beleive the command is either &[Directory] or & [Path]. But when I manually type this command in,it comes up as text, it does do the function. I have looked in the Toolsmenu, Customize, to see if I can even find the icon to add it, but it is not there either. I did find a command to enter to get the directory, =info ("directory") but the problem with this is it would have to be manually entered in each workbook and if the workbook is more than one page long, it will only appear on the first page. Any ideas?? . |
#3
|
|||
|
|||
Someone gave me this link and I think it works well:
http://www.xldynamic.com/source/xld.xlFAQ0002.html "Insert a Directory Path in Header/Footer" wrote: I have Windows XP operating sys and Excel 2000 version. I am trying to insert my directory path in my Excel document. In older versions of Excel and other operating systems, ie. Windows 2000, there is an icon in the "Header/Footer" [File Menu, Page Setup, Header/Footer tab] where you can click to add the directory whether it is on the C: drive or a shared network drive, ie. S; drive. The other 2 options are the add the file name &[File] and tab name &[Tab] in any given workbook you are in. In other versions, when you click on the icon, I beleive the command is either &[Directory] or &[Path]. But when I manually type this command in,it comes up as text, it does do the function. I have looked in the Toolsmenu, Customize, to see if I can even find the icon to add it, but it is not there either. I did find a command to enter to get the directory, =info("directory") but the problem with this is it would have to be manually entered in each workbook and if the workbook is more than one page long, it will only appear on the first page. Any ideas?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reflect file path (show drive letters) in Excel 2000 | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
How to change the Excel Title Bar to show the full file path na... | Excel Discussion (Misc queries) | |||
How do I insert an Excel file into a PowerPoint Presentation slid. | Excel Worksheet Functions | |||
How do I insert an Excel file into a PowerPoint Presentation slid. | Excel Discussion (Misc queries) |