Analyst Excel add-in / VB macros

[snowy]

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?

[ykud]

An anticopyright advice, never follow it ;)
You can "open" analyst add-in excel modules and see the exact function calls.

[snowy]

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...