I'm trying to take advantage of the INFO("directory") function, and it's not behaving the way I want. It's supposed to point to the directory where the Excel file is.

For example, I create a new Workbook on my Desktop, type in =INFO("directory") and I get "C:\Documents and Settings\Joe\Desktop\"

If I close Excel, move the document to C:\, open the file, the INFO now shows "C:\Documents and Settings\Joe\My Documents\" even though it isn't there. Additionally, when I delete the cell and type in the INFO function again, it shows the same thing.

What the deal with this? If it would reflect the current directory at all times, this would save me a ton of time.

Thanks

4/18/2006 6:12:50 PM

press F9

what are you using this for anyways? there may be a better solution

[Edited on April 18, 2006 at 6:23 PM. Reason : f9 is flaky though]

4/18/2006 6:14:30 PM

hmm, no dice on F9.

I tried all combinations, F9, Ctrl Alt F9, etc. The odd thing is that it defaulted to My Documents after I relocated it, even though it initially was on my Desktop.

I'm hyperlinking some pdf files into the document, but need to make sure that the links are relative, so the excel file (and accompanying pdfs) can exist at any location and still be active hyperlinks

edit: so im doing something like =HYPERLINK(INFO("directory") & "data\pdf1.pdf", "link name")

4/18/2006 6:23:46 PM

I found an alternative solution. The INFO("directory") just points to the current working directory, so it's a hit or miss as to why it doesn't always work. You'd have to change the working directory to get it to work correctly. The alternative solution is:

=LEFT(CELL("filename"),FIND("[",CELL("filename"))-1)

and it works like a charm

4/18/2006 6:53:38 PM

sonofabitch

Going to Insert > Hyperlink maintains the relative position of linked documents w.r.t the original document

all that bullshit code for NOTHING

excel 1
joe 0

4/19/2006 2:35:59 AM