linking to web page

J

Joe

I wish to link to a web page copy the information to the
clipboard and paste this as plain text onto an excel
sheet. Any help with achieving this or pointers to
articles would be appreciated.
Ta
 
S

Stephen Bullen

Hi Joe,
I wish to link to a web page copy the information to the
clipboard and paste this as plain text onto an excel
sheet. Any help with achieving this or pointers to
articles would be appreciated.
Click to expand...

It might be easier to use a web query. Click on Data > Import External
data > New Web Query and follow the wizard.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.ie
 
J

Jake Marx

Hi Joe,
I wish to link to a web page copy the information to the
clipboard and paste this as plain text onto an excel
sheet. Any help with achieving this or pointers to
articles would be appreciated.
Click to expand...

As Stephen noted, you can use the Web Query feature to do this. If you are
looking for a programmatic solution, you can automate IE:

Public Function gsGetURLText(rsURL As String) As String
Dim ie As Object

Set ie = CreateObject("InternetExplorer.Application")

With ie
.Navigate rsURL
Do Until ie.ReadyState = 4 And Not ie.Busy
DoEvents
Loop
gsGetURLText = .Document.Body.InnerText
.Quit
End With

Set ie = Nothing
End Function

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]
 
Top