Trouble Checking for Add-in Update

I've written an Add-in in Excel VBA. I'm made a function to check for updates. It uses ie, and looks something like this:

Please Login or Register  to view this content.

Now I can test that out by running it manually from the Macro dialog. It works great!

My problem is, that I want this sub to run automatically whenever Excel runs. I've tried calling it from "Workbook_Open()" in my add-in, but I found that calling it from there prevents the workbook from opening fully. Excel just displays a grey screen. Not sure what's wrong.

Anyway, when should my update sub get called?

Thanks!

Just to be even more clear, if you create and add-in with this code:

Please Login or Register  to view this content.

Then save it (as add-in .xlam) and activate it. After that I cannot open any Excel files. I just get the message box and then a grey screen. What's going on?

Also, I'm using Excel 2013 x64.

This line does not appear to me as a correct
If HTML.DocumentElement.innerHTML = "update is available" Then
I suspect the code is freezing because IE is terribly slow and you should use HTTP request instead

Thanks. Can you give me an example of using http request?

What do you want to do with code? Here is the bare minimum. It gives you to open and send request. Once you have access, you can play with web page as you do with IE.

Please Login or Register  to view this content.