VBA to Update Several Query Tables from Web Page Fails

Dear Experts,

I recently come across Query Tables to access Web data on Stock information, and got codes as below, but somehow fails in the line "SET QT = ……"

Note that there are several Query Tables intended to access several web page data (only one exists in below uploaded file)

Please Login or Register  to view this content.

I've tried hard to modify the codes, but never able to pass the line "SET QT = ….."

Grateful if anyone could help.

Many thanks in advance.

Hi,

as any collection always ends with a 's' you just made a typo for QueryTables ‼ Like you can check within the VBA inner help …

Sorry, in fact I've tried before by adding s to QueryTables, but still failed.

You may try testing the codes by downloading the Excel (but remember to add "s").

Thx again