VBA/macros for Excel Add-In

VBA/macros for Excel Add-In

As a model builder I would like VBA and macros to be supported in the Excel Add-In so that I could further automate workbooks.


For example :


1) I would like to be able to create VBA code and macros for the various Anaplan actions so that I could automate a number of tasks (eg Login and refresh data) through macros



2) I would like to be able to understand, write and use Anaplan functions within a worksheet to dynamically create code to retrieve & write back functions. Below is a screenshot with my assumed, partial and most probably wrong understanding on how some of it works at the moment.

I basically tried to test my understanding writing a new CHOOSE function to retrieve other values, and it didn't work...I must have completely misintepreted how it could work 🙂




The purpose of this idea is mainly to understand if & how the community could benefit from these type of enhancements. 

Personal thoughts : from my point of view the potential application could be beneficial for different types of data reconciliation. Having said that, this could all be done within Anaplan itself and I'm tempted to think it could be better to create ad-hoc developments there or maybe raise specific Ideas for new Anaplan functionality to support these type of requirements ? 


Master Anaplanner/Community Boss


Awesome idea. I share the same sentiment.

I think we should set up a demo mtg with @MagaliP at some point so she can see the specific use-cases for how we would use this.

My most popular use case is to take the user stories out of the Anaplan Way App into Excel. From there, I use VBA to reformat the data. Lastly, I wrote PowerPoint VBA to generate one slide per user story. Here's a sanitized example below:



Community Manager
Status changed to: Your support is needed
Certified Master Anaplanner

Hi @JaredDolich , 

Thanks for the feedback and for sharing what you did. Your use case looks so neat and tidy : good job!

Happy to jump on a quick call/contribute, if it helps.

I was wondering if you have considered using the New UX for it ?

I'm suggesting it as I recently had a requirement that could potentially be seen as vaguely similar. I had to share a spreadsheet with Anaplan (inc images) and we couldn't find a suitable tool for it.

The New UX seems to be working quite well for it - see below. Assuming there are no licence implications perhaps something similar could work for your use case ? Chances are you already considered that 🙂 

Of course T&Cs would apply to what images could/can't include and where they are stored....


Generally speaking I'm curious to see if/how all the current apps would have their New UX apps. This could also provide helpful ideas/inspiration to the wider community.






Certified Master Anaplanner

We are investigating point 1 of @Alessio_Pagliano 's idea. What do you think of being able to do the 3 things with VBA macros:

  1. Login
  2. Refresh all
  3. Change a page selector

@JaredDolich - I would love to have a chat with you and see the templates you are using. I will direct message you.

Status changed to: Under Investigation
Users Online
Currently online: 141 members 356 guests
Please welcome our newest community members: