Getting Data for excell off of the internet

C

ChrisG

I think I may be reaching with this, but is there a way for excel to program
excel to obtain infromation off of the internet? I think I may be asking for
too much, but I guess it doesn't hurt to ask!
 
A

Alan

There is, look at Data > Import External Data. There are issues concerning
non Excel formatting etc but it can be done. Have a look and post back if
there are problems.
Regards,
Alan.
 
G

Gord Dibben

Yes it can be done using Data>Import External Data>New Web Query.

Can be done manually by following the steps you find there.

This could all be automated using VBA.

I'm not your man for the VBA part but I'll bet someone has a routine already set
up for such an operation.


Gord Dibben MS Excel MVP
 
D

DS-NTE

Sth like this maybe? Watch for linewraps!

Record a macro when performing the steps Data>Import External Data>New Web
Query

Sub HentSvenskPris()
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;http://www.nordpool.com/marketinfo/...ot.cgi?interval=last8&ccurrency=nok&type=html"
_
, Destination:=Range("A1"))
.Name = "elspot.cgi?interval=last8&ccurrency=nok&type=html"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.WebSelectionType = xlSpecifiedTables
.WebFormatting = xlWebFormattingNone
.WebTables = "4"
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.Refresh BackgroundQuery:=False
End With
End Sub
 
Top