ERLANDSEN DATA CONSULTING Excel & VBA Tips   Informasjon på norsk / Information in Norwegian

These pages are no longer updated and are only available for archive purposes.

Click here to visit the pages with updated information.

Userdefined functions from other workbooks

You can use a userdefined worksheet function (UDF) from another workbook like this:

=OtherWorkbookName.xls!FunctionName(A1)

If you add a reference in the VBE (press Alt+F11 to open) to the other workbook with the UDF's, you can reference the functions like this:

=FunctionName(A1)

If you make an addin out of your workbook with the UDF's, you can reference the functions like this without creating any references (the add-in must be installed in order for the function to work):

=FunctionName(A1)

 

Document last updated 2002-07-17 12:45:07      Printerfriendly version

 

Erlandsen Data Consulting     http://www.erlandsendata.no/   
Excel & VBA Tips   Copyright ©1999-2017    Ole P. Erlandsen   All rights reserved
E-mail Contact Address