Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use External Function
I want to use a function defined in one workbook within the VBA code of
another workbook. My code looks like b = 0 a = [personal.xls].UseIsOK(b) but I get an error message run time error 424 object required The called function requires no arguments, but I get the same error message if I use a = [personal.xls].UseIsOK() or a = [personal.xls].UseIsOK Any help would be appreciated. Thanks. Marvin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use External Function
a = Application.Run( "personal.xls!UseIsOK") -- Regards, Tom Ogilvy "Marvin" wrote: I want to use a function defined in one workbook within the VBA code of another workbook. My code looks like b = 0 a = [personal.xls].UseIsOK(b) but I get an error message run time error 424 object required The called function requires no arguments, but I get the same error message if I use a = [personal.xls].UseIsOK() or a = [personal.xls].UseIsOK Any help would be appreciated. Thanks. Marvin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to run external workbook function/procedure? | Excel Discussion (Misc queries) | |||
call external function | Excel Worksheet Functions | |||
OFFSET() function with external references | Excel Programming | |||
Using a function from a vba add-in: is that considered an external link | Excel Programming | |||
External function call | Excel Programming |