Add-in and Automation functions (reference)

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




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

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.