Add-in and Automation functions (reference)

Click one of the links in the following list to see detailed help about the function.

Function

Description

CALL

Calls a procedure in a dynamic link library or code resource

EUROCONVERT

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)

GETPIVOTDATA

Returns data stored in a PivotTable report

REGISTER.ID

Returns the register ID of the specified dynamic link library (DLL) or code resource that has been previously registered

SQL.REQUEST

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

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×