Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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". |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP: How to call UDF defined in another workbook?
On Dec 9, 11:57 am, wrote:
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? Never mind! Dave Peterson already providing instructions to do this in another thread. I will try those instructions first. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Call user defined function in an add-in | Excel Programming | |||
How to call a function of an user defined DLL from Excel? | Excel Programming | |||
How map types when call functions defined in XLL AddIn from VBA | Excel Programming | |||
How to call a sub defined in macro when double click a cell? | Excel Programming | |||
Call GoalSeek from a user-defined-function | Excel Programming |