Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Agent to get source code
Hi,
I found this code on this group forum. but I have problem, I just do not want to pull source code. I want to pull source code by setting User Agent. Is there a way to get source code by changing User Agent to like iPhone or iPad? Thanks Sub Tester() Range("B2").Value = GetSource("http://www.google.com") End Sub Function GetSource(sURL As String) As String Dim oXHTTP As Object Set oXHTTP = CreateObject("MSXML2.XMLHTTP") oXHTTP.Open "GET", sURL, False oXHTTP.send GetSource = oXHTTP.responsetext Set oXHTTP = Nothing End Function |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Retreive data for same agent | Excel Worksheet Functions | |||
How do I obtain Microsoft Agent 2.0 or later? | Excel Discussion (Misc queries) | |||
prompt user to change source of links | Excel Discussion (Misc queries) | |||
VB Code Source | Excel Programming | |||
user form to copy and paste from source to destination | Excel Programming |