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/
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/