PDA

View Full Version : Import specific cells from a website table



xlcior
05-17-2012, 11:30 AM
Hi,

I am trying to import specific cells into Excel from a table on a website. How can I do this? Let's say I want to import specific cells from the "Key stats and ratios" table on Google Finance. For example:

google [dot] com/finance?q=NASDAQ%3AGOOG

I found a forum that helps users import tables into Excel; however, I have been completely unsuccessful with the Like operator. I don't think the table has a tag or name so I think I need to use vba code that imports specific cells from the "x"th table on a page. Is this possible? Here's the other forum that discusses pulling info from a table:

tek-tips [dot] com/viewthread.cfm?qid=1458220e

Thanks in advance for any help!!!