I'm a little bit new to VBA. I've been working on it for only about 2 weeks.
This problem doesn't seem like a VBA problem.But i just think that maybe VBA could solve my problem.
The thing is, I wish to import data from this web -http://www.tfex.co.th/tfex/dailyMarketReport.html
Your shouldn't be able to read it because it's in Thai.
But here's the deal, if you scroll to the last table of the page,
you should see something like "SET50 Index Call Options". At the
bottom of the table, there are some links which type in Thai ,but
I think you could see as something like this -- "?.?.52","?.?.52"
,"??.?.53" (they're month and year in Thai). Now, this links actually
contain Java script, so if I open one of these links the table contain
data in each month and year appear leaving NOTHING CHANGE WITH THE URL
IN THE ADDRESS BAR. So, I want to get all those data (from every month
and year) but I can't get it done with "Web Query" in "Import external
Do you have any suggestion on that??
Thanks in advance... ^o^