how to create RELATIVE PATH link of Excel sheet in Acceess?

[Guest]

From Access, i need to access data colected in Excel, by linking.
Generally it works, but i cannot move excel table threw directories without
severing Accesses connection. I don't mind moving them together. If i could
make them work while in same directory it would be fine.
I've tried "..\table.xls"which dos not work, and i cant think of anything
else.

Please help if possible.

 

[Brendan Reynolds]

From Access, i need to access data colected in Excel, by linking.
Generally it works, but i cannot move excel table threw directories
without
severing Accesses connection. I don't mind moving them together. If i
could
make them work while in same directory it would be fine.
I've tried "..\table.xls"which dos not work, and i cant think of anything
else.

Please help if possible.

You can get the path of your Access app using the CurrentProject.Path
method. For example, in the Immediate window ...

? CurrentProject.Path
C:\Users\Brendan Reynolds\Documents\SCCC

Note that the final trailing backslash isn't included, so remember to
include that when concatenating the path and file name ...

strSomeString = CurrentProject.Path & "\" & strSomeFileName