This is the documentation you want: https://docs.oracle.com/applications/smartview/720/SVDVG/toc.htm
It contains all the functions you need for setting up & using VBA with Smart View (e.g. the proper connect functions for Smart View rather than EssVConnect). Sounds like you were looking at stuff from the old Essbase Excel Add-In
Splendid - thanks very much, Daniel!
Perhaps a rookie question but I am trying to use the HypUIConnect to connect to the server on an existing sheet which requires "URL|server|app|db". Just wondering how I can figure out the last bit, i.e., the database name? Is it the same as "Cube"?
Database name and cube name are both the same.
What add-in are your users using, Smart View; or, the old legacy Spreadsheet add-in?