Hello everyone,
I am working on the VBA code to extract the data from website using API link. i trying to use regex to scoop out the portion for exchange rate for usd_sgd & jpy_sgd_100 into same worksheet in cell B2 & C2. I try to use if else then statement for 2 different pattern "usd_sgd" and "jpy_sgd_100". After i run the code, it compile error "Run time error 424 object require" on line:For Each match In matches. I just wanted to extract exchange rate data for "usd_sgd" and "jpy_sgd_100" from the same API link into same worksheet in cell B2 & C2 after run the code. I am appreciate someone can guide me on this. Thank you in advance!
VBA code as per attached.
Bookmarks