ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Citrix and FullName (https://www.excelbanter.com/excel-programming/415247-citrix-fullname.html)

Jonathan West

Citrix and FullName
 
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




All times are GMT +1. The time now is 10:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com