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..

[VBA]Sub URL_refresh()

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

End Sub
[/VBA]


thanks very much.

[mancubus]

hi.

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

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

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
[VBA]
Sub URL_refresh()
Dim URL$
URL = "http://www.google.com"
Sheets("WebData").WebBrowser1.Navigate URL
Sheets("WebData").WebBrowser1.Refresh
End Sub
[/VBA]

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

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 ..