Determining current directory of excel file using Excel SAS Add-in

[saskupo]

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;

[tomrvincent]

=LEFT(CELL("filename", A1), FIND("[", CELL("filename", A1))-1)