User defined functions that are installed with add-ins

If add-ins that you install contain functions, these add-in or automation functions will be available in the User Defined category in the Insert Function dialog box.
 Note    User-defined functions (UDFs) are not available in Excel Web App.

Function Description
CALL function Calls a procedure in a dynamic link library or code resource
EUROCONVERT function Converts a number to euros, converts a number from euros to a euro member currency, or converts a number from one euro member currency to another by using the euro as an intermediary (triangulation)
REGISTER.ID function Returns the register ID of the specified dynamic link library (DLL) or code resource that has been previously registered
SQL.REQUEST function Connects with an external data source and runs a query from a worksheet, then returns the result as an array without the need for macro programming

Post a Comment

Blogger

Your Comment Will be Show after Approval , Thanks

Ads

 
[X]

Subscribe for our all latest News and Updates

Enter your email address: