copy & paste from webbrowser.

[KK1966]

Hi, all experts

I need your help to how’s copy all data from the “an excel webbrowser” to a worksheet? I just know like that below than want your help..

Sub URL_refresh()

Sheets("WebData").WebBrowser1.Navigate "URL"
Sheets("WebData").WebBrowser1.Refresh

End Sub



thanks very much.

[mancubus]

hi.

try

Sub URL_refresh()
Dim URL$
URL = "http://www.google.com"
Sheets("WebData").WebBrowser1.Navigate URL
Sheets("WebData").WebBrowser1.Refresh
End Sub


or

Sub URL_refresh()
Sheets("WebData").WebBrowser1.Navigate "http://www.google.com"
Sheets("WebData").WebBrowser1.Refresh
End Sub


a topic on WebBrowser Control:
http://www.vbforums.com/showthread.php?t=384076



ps: btw, i do not know how to copy data from worksheet WebBrowser control to worksheet. why not import data from web? (Data, Get External Data, From Web)

[KK1966]

hi.

try

Sub URL_refresh()
Dim URL$
URL = "http://www.google.com"
Sheets("WebData").WebBrowser1.Navigate URL
Sheets("WebData").WebBrowser1.Refresh
End Sub


or

Sub URL_refresh()
Sheets("WebData").WebBrowser1.Navigate "http://www.google.com"
Sheets("WebData").WebBrowser1.Refresh
End Sub


a topic on WebBrowser Control:
http://www.vbforums.com/showthread.php?t=384076



ps: btw, i do not know copying data from worksheet WB control to worksheet. why not import data from web? (Data, Get External Data, From Web)



Thanks the suggested ..