PDA

View Full Version : Scrape data from website to excel - VBA



sudsar04
07-21-2013, 02:43 PM
Hi,

I am trying to get data of CEO, CFO, COO of a specific company. I have the company name located in Cell A2 and the Ticker in B2, Webpage in E2. I want to have the CEO in F2, CFO in G2, COO in H2. I have found the website that holds the data for most of my requirements. If some one could help me with VBA code to collect the data from the website and paste it on Excel.

Example:

Xerox Corp|XRX|||investing(dot)businessweek(dot)com/research/stocks/people/people(dot)asp?ticker=XRX|

Any other website suggestions are also appreciated.

Thanks