Got a bit of a problem. I'm working on an XLA add-in which has an associated
data file. I've put the data file in the same folder as the add-in. On
distribution, I won't know which folder both will be in, so I identify the
folder using the ThisWorkbook.Path property.

The problem occurs when the add-in is loaded onto a Citrix system.
Unfortunately, ThisWorkbook.Path returns the underlying file path of the
file on the Citrix server's C drive, which of course is not accessible to
ordinary users. What I need is the equivalent path of the mapped drive
accessible to the user.

Anybody know how I might correctly identify that path?


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup