Automatically open Tiller add-in?

Is there a way to automatically open the Tiller add-in (sidebar) after opening the Tiller workbook in Excel? I tried using Applescript (I’m on a Mac) and VBA to automate this, but the solutions I found appear to only work on old-style XLA add-ins, not the new Javascript API-based add-ins like Tiller Money Feeds.

I understand what you are trying to do but I’m not aware of a workable solution. Generally, to protect privacy, the platform APIs for both Sheets and Excel try to avoid add-ons/ins from auto-launching and manipulating data without a direct intervention from the user.

If you find something that works, please let us know!

Thanks – I thought I might have been missing some obvious solution, but it seems like not.

The privacy explanation sort of makes sense, although I don’t think that’s really the case in Google Sheets – when I was still using Sheets, I had set Tiller to automatically update in the background and run Autocat after fetching new transactions. The sheet was always ready for me to check over categorization as soon as I opened it up, whereas it takes a few clicks and some waiting to get there in Excel. Not enough of a hassle to spend much more time on, though.

Here’s something that’d help – it looks like it’s possible to assign keyboard shortcuts to Javascript-based add-ins[1], but only the add-in developer can do this.

Does the Tiller add-in already have keyboard shortcuts associated with it? If not, is it possible to add shortcuts to open and close the task pane?

[1] Can’t post a link here, but Microsoft has a relevant code sample if you search for “Use keyboard shortcuts for Office Add-in actions”