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

saskupo — Thu, 05 Sep 2019 06:42:08 GMT

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;

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

tomrvincent — Mon, 21 Oct 2019 18:51:02 GMT

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

topic Determining current directory of excel file using Excel SAS Add-in in Microsoft Integration with SAS

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

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