PDA

View Full Version : Import Table With No ID From Internet



alpignolo
08-28-2013, 12:49 PM
Hello,

I need to import a table from the web in excel using VBA.

The web site is in the attachment.

and the table I need is the "Annual Income Statement Data" in the middle of that page.

The problem is that, it is not possible to use the "import from web" procedure of excel because excel does not recognize this table and importing all the page doesn't work either. I really don't have a clue on how I should proceed and/or which resources/knowledge I need.

I would be grateful to anyone will be able to help me with this issue.

Thank you in advance

Moderator Edit: Link Attachment deleted.
Link is http://www.4-traders.com/STANDARD-CHARTERED-PLC-9743797/financials/

SamT
08-28-2013, 01:30 PM
alpignolo,

Welcome to VBAExpress. I edited your thread title to be a little more self explanatory.

@ All: The internet link in the OP attachment is

http://www.4-traders.com/STANDARD-CHARTERED-PLC-9743797/financials/