PDA

View Full Version : [SOLVED] How to link to a file one folder up.



kane
06-01-2005, 03:52 PM
I'm using this code in a file called main.xls which is in folder1.
ActiveWorkbook.FollowHyperlink "base.xls"

I'm using this code to link to base.xls which is outside folder1.

What do I need to do to get this to link to a file right outside the folder?

Thx,

kane
06-01-2005, 06:00 PM
I got what I wanted with this. Where the name of the folder was "1.0"


Dim FilePathIs
FilePathIs = Left(ThisWorkbook.Path, Len(ThisWorkbook.Path) - 3)
ActiveWorkbook.FollowHyperlink FilePathIs & "Base.xls"


Any better ideas still accepted.:hi: