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

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" wrote:

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

Works great, thanks keepITcool.

"keepITcool" wrote in message
...
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" wrote:

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