• 114 views | 1 messages Discussion: LEAP
    Topic: LEAP API - Get result for All RegionsSubscribe | Previous | Next
  • Gregers Larsen 1/31/2019

    Hello LEAP team!

    I am trying to automate the Energy Balance method to Excel, as we need this for a project.

    I kept getting results, but always the wrong number. I have figured out my code kept referring to a specific region, not "All Regions". I am interested in the total number though.

    I have tried specifying "All Regions" in different ways, but I get errors instead. How do You define "All Regions"? I have tried "ActiveRegion = "All Regions"", which makes the macro run forever. I have tried using "All Regions" and "" in .ValueR, but that fails.


    Do I have to run it for each specific region? That seems like a waste.


    Gregers