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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
vskarica said:
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.
Click to expand...


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
 
Back
Top