Managing Multiple Workbooks

Add-in Express™ Support Service
That's what is more important than anything else

Managing Multiple Workbooks
Chris Bishop

Posts: 13
Joined: 2016-01-25

I was wondering if there was a standard way of dealing with multiple workbooks in the same session.
What I mean is I have state per workbook since the Add-in is a global state. Currently I have my own state manager that when the events are triggered int he add-in I use the filename of the workbook as a key to return the state for that workbook.

Is there a better way of handling this? I tried to look for a Tag (TObject) on workbook with the hopes of using it for state but didn't find one.
Posted 12 Apr, 2017 10:32:10 Top
Andrei Smolin

Add-in Express team

Posts: 14137
Joined: 2006-05-11
Hello Chris,

I believe this is the best way. You use the Workbook.FullfileName property to identify a work book.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 13 Apr, 2017 05:55:05 Top