View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] oitbso@yahoo.com[_2_] is offline
external usenet poster
 
Posts: 13
Default Capture Web Page Source Code

Don...Thanks for pointing that out. With your url, the information is not in a frame so I can simply use
my_var = ie.document.body.innerhtml

Better yet, I don't even need to open IE. With your url the "GET" method works just fine.
Set my_obj = CreateObject("MSXML2.XMLHTTP")
my_obj.Open "GET", my_url, False
my_obj.send
my_var = my_obj.responsetext
Set my_obj = Nothing

....Ron