Curious if anyone has figured out a way to use VBA or VB script to click “Fill Available Updates” and then refresh the data in the spreadsheet using Windows Scheduler? Not a big deal to have to do this manually, but it would be cool to be able to take that one further step in automation if it’s possible. Thanks!
Kyle
Step further indeed! Looking forward to those workflows here 
No It isn’t possible as Tiller doesn’t expose their tools or function with an api. Given how slow the dev roadmap is, I doubt they ever will.
Sounds good - thanks all!
I just wanted to add my two cents in case anyone from the developer team is reading this thread. I would very much be interested in a feature to have Excel be able to automate refreshing the account information. To be able to launch Excel from another program like Microsoft Access, have it refresh the data in the background, and Save and Quit would be a wonderful addition.
Hi @amicron thank you for the feedback. We have feature request posts for such great ideas. You might find these align with some of yours:
Tiller Data Feed for Microsoft Access
Excel Update Via Macro
Please search for other similar ones and vote them up. Also feel free to add new ones if you have more nuanced ideas.
Hi Twalane,
Thanks for the reply, I appreciate it!
Perfect timing actually, because I just posted updates in both of those feature request threads you linked:
Tiller Data Feed for Microsoft Access
Excel Update Via Macro
In both posts, my main request is basically the same: I’d love to see Tiller expose some kind of supported automation “hook” so we can refresh Tiller data programmatically (VBA/macro/command), which would enable workflows like:
Open Excel in the background (even launched from Access or a scheduled task)
Trigger the Tiller refresh process automatically
Close Excel
Then consume the refreshed data (Access, reporting, automation, etc.)
Right now linking/importing data works fine, but without a way to trigger the update process automatically, there’s still a manual step that prevents full automation.
Anyway, I voted them up and added my notes to help clarify the use-case. Thanks again for pointing me to the right place.
@amicron sounds good ! Happy to help.
