Did you try Cell("filename",A1) or something like that? You may need to
strip out the [ and ] and the the sheet name from this though.

"MikeF" wrote:


Need to put a hyperlink in a cell, say ax2, with the current drive
letter\path\filename and nothing else.

The hyperlink will be imported into an Access table, and needs to be what
will get me back to this Excel file.

Have tried lots of INFO and CELL formulas, they all *look* like they work,
but don't in Access.
The only thing that works is manually copying the path from the locator bar,
and that is, well, no fun!

Regards,
- Mike