Prev: I am trying to write a macro using If...Then
Next: date formatting
From: hawaiiham2000 on 22 Mar 2010 11:05
I am trying to import a table from a website into Excel that automatically
refreshes and can be used in formulas. I was successful in doing this with a
currency exchange website, but am having difficulty with this website in
particular:

http://www.cmegroup.com/trading/energy/crude-oil/light-sweet-crude.html

I did the following steps:
from the Ribbon

DATA
FROM WEB
http://www.cmegroup.com/trading/energy/crude-oil/light-sweet-crude.html
CLICKED FIRST YELLOW ARROW TO THE LEFT AND ABOVE "MONTH"
OPTIONS - FULL HTML FORMATTING
IMPORT
PROPERTIES
OVERWRITE EXISTING CELLS WITH NEW DATA...
FILL DOWN FORMULAS IN COLUMNS...
OK
OK

Part of the table is inserted, but the numbers do not display.

Any hints?
Thanks!





 | 
Pages: 1
Prev: I am trying to write a macro using If...Then
Next: date formatting