Getting Data for excell off of the internet
 

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!

Getting Data for excell off of the internet
 

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.
"ChrisG" wrote in message
...
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!

Getting Data for excell off of the internet
 

Yes it can be done using DataImport External DataNew 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

On Wed, 31 Jan 2007 15:35:01 -0800, ChrisG
wrote:

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!

Getting Data for excell off of the internet
 

Sth like this maybe? Watch for linewraps!

Record a macro when performing the steps DataImport External DataNew Web
Query

Sub HentSvenskPris()
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;http://www.nordpool.com/marketinfo/elspot/stockholm/elspot.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

"ChrisG" skrev i melding
...
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!