PDA

View Full Version : copy & paste from webbrowser.



KK1966
08-17-2011, 06:15 PM
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
08-18-2011, 01:53 AM
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
08-18-2011, 02:00 AM
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 ..