Can you please tell me how to get the ActiveWorkbook name/path from inside an XLL?

Posted by David A Henry on November 27, 2000 10:19 AM

There are Excel functions to get the ActiveCell and Selection but non that I can find to get the full path of the ActiveWorkbook. I know there must be some way to get this information. I would really appreciate if someone could point this out to me. Thanks a lot.

Posted by Ivan Moala on November 28, 2000 12:09 AM

Something like;

Dim FullName as Sting

FullName = ActiveWorkbook.FullName

HTH

Ivan

Posted by David A Henry on November 28, 2000 6:43 AM

I said from a XLL not a COM Add-In.

Something like?

static XLOPER x1, xSheetName;
x1.xltype = xltypeInt;
x1.val.w = 1;
Excel4(xlfGetDocument, &xSheetName, 1, (LPXLOPER) &x1);

????????????????????????

I dunno?