David Montoya
New Member
- Joined
- Apr 25, 2018
- Messages
- 49
Dear,
I have a worksheet with multiple macros, which access different network resources; the problem I have it that when working from a Citrix environment the network resources are not the same, and I have to maintain two different version of the worksheet, one for each environment.
Is there a way to build into the macro a check to the regular network path, and if it is not reachable to change to the Citrix path? I mean similar as when if directory does not exist, then to create it, not that I want to create the directory, because it already exist.
The following are the begging of both environment paths:
Regular network path
Citrix environment path
In both environments, after the "$" is the regular directory\Folder\File names.
Thanks a lot.
I have a worksheet with multiple macros, which access different network resources; the problem I have it that when working from a Citrix environment the network resources are not the same, and I have to maintain two different version of the worksheet, one for each environment.
Is there a way to build into the macro a check to the regular network path, and if it is not reachable to change to the Citrix path? I mean similar as when if directory does not exist, then to create it, not that I want to create the directory, because it already exist.
The following are the begging of both environment paths:
Regular network path
Code:
\\wlsite\WLdepts$
Citrix environment path
Code:
\\Client\I$
In both environments, after the "$" is the regular directory\Folder\File names.
Thanks a lot.