amittal6 wrote:
Alternatively you could just use HYPTUSS as is.
Thanks mc2fool. I tried but not able to go past the code error issue. Could you suggest?
I take it you didn't just use HYPTUSS as is, nor my "even easier way" suggestion but rather tried copying the code into your own spreadsheet...
amittal6 wrote:I think the problem in HYPTUSS tool is with below line:
Set html = New HTMLDocument ' New MSHTML.HTMLDocument
You don't say what the actual error you get is, but my guess is that you're missing the object library reference for the HTML object; maybe others too.
Go into the VBA Editor in both HYPTUSS and your spreadsheet and select menu item Tools->References and make sure the same libraries are ticked in yours as in HYPTUSS.