Excel Add-in and Automation Functions Cheatsheet

Function

CALL EUROCONVERT GETPIVOTDATA REGISTER.ID

SQL.REQUEST

Add-in and Automation Functions Description

Calls a procedure in a dynamic link library or code resource 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) Returns data stored in a PivotTable report Returns the register ID of the specified dynamic link library (DLL) or code resource that has been previously registered 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

Source

NOTE: The functions on this cheatsheet will be available in the User Defined category in the Insert Function dialog box provided that the add-ins you install contain functions.

Try Able2Extract Professional Free

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download