Hello everyone
I try to to extract or get data from HTML Element in Excel using VBA code as per attached file named "VBA code - Extract Data from HTML web".
My idea is to extract the exchange rate data in red highlight from the HTML website as below quote and unquote:
Quote//
SG : 1.3006 SGD = 100 JPY 2020-06-15 MAS noon buying
100 Japanese Yen buys 1.3006 Singapore Dollars
SG : 1.3001 SGD = 100 JPY 2020-06-12 MAS noon buying
100 Japanese Yen buys 1.3001 Singapore Dollars
SG : 1.2986 SGD = 100 JPY 2020-06-11 MAS noon buying
100 Japanese Yen buys 1.2986 Singapore Dollars
SG : 1.2887 SGD = 100 JPY 2020-06-10 MAS noon buying
100 Japanese Yen buys 1.2887 Singapore Dollars
SG : 1.2857 SGD = 100 JPY 2020-06-09 MAS noon buying
100 Japanese Yen buys 1.2857 Singapore Dollars
SG : 1.2726 SGD = 100 JPY 2020-06-08 MAS noon buying
100 Japanese Yen buys 1.2726 Singapore Dollars
SG : 1.2773 SGD = 100 JPY 2020-06-05 MAS noon buying
100 Japanese Yen buys 1.2773 Singapore Dollars
Unquote//
Unfortunately, when i try to run the code, it compile the error as "run-time error 445" and "object doesn't support this action"
Appreciate someone can guide me to find out what is the error.
Bookmarks