I'm hoping to get some help talking to leap through an API. Currently I'm using the visual basic script editor in excel to extract tables saved as favorites in LEAP. This works fine. However, we have a long messy list of favorites. It would be ideal if we could put the favorites in to folders. However, I can't figure out how to refer to favorites in folders in the LEAP code.

For example, we have a folder called "Final Report". In that folder, there's a table called "emissions" saved as favorite.

If I save the emissions table as a favorite list outside of the folder, I can access it no problem. However, trying to access it in the folder, referring to it as "Final Report\emissions" throws an error.

Any suggestions on syntax or work arounds?

Thanks!

Kate

Try using the # character to delimit folder separations. For example:

"Final Report#emissions"

Let me know if this works,

Taylor