Hello Everyone,

I'm new to the forum and also very new to Excel VBA. I'm trying to scrape some data from a financial website:

http://www.aastocks.com/en/Stock/Com...4&symbol=00238

I would like to pull the data from the table with all the relevant financials (nested tables?), and ideally I would like to automate the process so that I can pull data from different tabs ("financial ratio", "profit loss", etc.) of the same stock ("Type=1", "Type=2", etc. in the url) of different stocks ("symbol=0001", "symbol=0002", etc. in the url)

Since I'm new to VBA, I tried to start with recording a macro of the actions of getting the table data via the Data->Get Data From Web function. However, the tables I want seem to be nested and I cannot select it and import cleanly. I have Excel 2013, so I tried recording a macro of pulling the data via "Data Explorer", but seems like nothing got recorded.

If anyone can kindly shed some light as to how I should proceed with this problem, that would be super awesome!

Thank you very much!!