VBA code to execute Excel Add-in toolbar commands

tphilpott
New Contributor

VBA code to execute Excel Add-in toolbar commands

Hi, 

I am a new Anaplan user and am looking at using the Excel Add-in 3.0 to retrieve data into my excel-based reports. My preference is to automate report formatting and retrieves from Anaplan using VBA.  Does anyone know if there are published Anaplan VBA commands like exist for Essbase?

Thanks!

2 REPLIES 2
hendersonmj
Contributor

Re: VBA code to execute Excel Add-in toolbar commands

There is no VBA toolkit but it ought to be possible to use SendKeys as a worrkaround for automating retrieves.
MagaliP
Community Boss

Re: VBA code to execute Excel Add-in toolbar commands

You may vote for this idea: https://community.anaplan.com/t5/Idea-Exchange/VBA-macros-for-Excel-Add-In/idi-p/69994

Magali Pelissier, Product Manager - Extensions (Excel Add-in, PowerPoint Add-in, Google Sheets Add-on)
Check out our dedicated Community page in the Platform section!