Neither Web query nor Copy/Paste working - Help!

[j844929]

Hi,

I'm trying to get the Live updating price information from DAX tab of the following URL:

http://www.finanzen.net/aktien/realtimekurse.asp?inindex=1

I can copy all and paste without a problem. The issue I am having is that the prices under "Bid" and "Offer" that I need aren't pasting to the worksheet, which is possibly something to do with the format in which they appear on the web page...

I've already tried the following without success:
1. Standard Web query

2. VBA Sendkeys copy/paste
Code:
Sendkeys ("^a")
Sendkeys ("^c")
Activesheet.Paste
/Code

3. VBA Select all, Copy and paste
Code:
IE.ExecWB 17, 0 '// SelectAll
IE.ExecWB 12, 2 '// Copy selection
Activesheet.Paste
/Code

If I copy the section of the web page outside VBA just using the mouse right-click=>copy=>paste as usual, it works perfectly. I just need to be able to select the data automatically... Can anyone help me out with a solution? I'm using Excel 2003.

Thanks,

Tim