Hello everyone. Long time lurker, first time poster.
I'm using the Analyst Excel add-in and I'd like to automate the Analyst | Refresh View function somehow. Ideally it would be called by a Excel Visual Basic macro, but right now I can't get VB to even recognise the existence of the Analyst add-in.
It's unlikely, I admit, but has anyone out there done anything like this before?
An anticopyright advice, never follow it ;)
You can "open" analyst add-in excel modules and see the exact function calls.
Thanks....I didn't just hear that! ;)
Unfortunately the Analyst.xls module is password protected; I'm not a good enough hacker to get past it; and I don't really fancy supporting the password-cracking software industry; so never mind. Manual refresh will just have to do. RSI here I come...