What workbook is calling the function

[Pierre Laporte]

I wrote a function that resides in an addin.

In the function I need to know what workbook is calling the function. It's
not the ActiveWorkbook, as the function may be called from a Workbook that
is dependant on the calling Workbook.

So the question is how do I determine the workbook that is calling the
function ?

Tks

 

[keepITcool]

dim wb as workbook

if typename(application.caller)="Range" then
set wb= application.caller.parent.parent
end if

sould do it


keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >

 

[Pierre Laporte]

Works great, thanks keepITcool.

dim wb as workbook

if typename(application.caller)="Range" then
set wb= application.caller.parent.parent
end if

sould do it


keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >