HELP: How to call UDF defined in another workbook?
What is the syntax and/or requirements for calling a user-define
function defined in another workbook that is already open in the
current instance of Excel?
(That is, both workbooks are open in the same instance of Excel.)
Details....
I have Module1 in the workbook timeit.xls. A function therein
(myfunc) needs to call another function (foobar), which is declared in
Module1 in the workbook binary.xls. If I were calling "foobar" from
an Excel worksheet in timeit.xls, the syntax that works is:
binary.xls!foobar("arguments")
That syntax does not work in VBA.
My book simply says to click on ToolsReferences. I don't know what
to do after that.
If I browse the file system and double-click the xls file, I get an
error ("name conflicts with existing module").
If I close the workbook binary.xls, then repeat the ToolsReferences
procedure above, binary.xls is opened (added to the Project Explorer
list), but I still get the error "name conflicts with existing module".
|