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:Thanks mc2fool. I tried but not able to go past the code error issue. Could you suggest?
Alternatively you could just use HYPTUSS as is.
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.amittal6 wrote:I think the problem in HYPTUSS tool is with below line:
Set html = New HTMLDocument ' New MSHTML.HTMLDocument
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.