I just discovered that there is a SAS Add-in in Microsoft Excel. I just want to know if there is a way to know the current directory of the excel file using the code that will be run in SAS Add-in inside excel. The excel is connected through SAS EG, server based. I have tried to use the following code but the result points to the location:
D:\SASConfig94\Lev1\SASApp94\
libname here '' access=readonly;
data _null_;
path = pathname('here');
call symput('xpath', trim(left(path)));
%put &xpath;
run;