EPM functions can be also used in automation operations performed in Excel's VBA (Visual Basic for Application) language, allowing users to create forms to simplify the usage of spreadsheets, as well as automating the generation of reports in Excel spreadsheets.

The example on the next topic shows how to generate a query to an EPM Server by simply clicking a button on a spreadsheet that executes a function written in VBA.