I'm using VBA and msXML to read response text from web page. Am having some problems.
The 2nd Open-Get statement has a flawed URL. The first URL reaches a page that has a thousand or more buttons on it that bring up another page when clicked. It returns 250,000+ characters to strPageContent1. I would like to how to set up the 2nd URL string that takes me to the same page that clicking ONE of the buttons on the first page would. I just don't know enough about reading the ResponseText from the first page to determine what that second URL should be. Can anyone offer a suggestion? If you could help me reach just ONE of the buttons, I could do the rest...
msXML.Open "GET",
"http://members.naca.net/findanattorney.php?submit=Search&name=&organizatio n=&city=&state=Any+State&zip=&areaofexpertise=none &levelofexpertise=any&sortorder=statesort",
False
msXML.Send
strPageContent1 = msXML.ResponseText
msXML.Open "GET", "http://members.naca.net/findanattorney.php/View",
False
msXML.Send
strPageContent2 = msXML.ResponseText
Set msXML = Nothing
MyString = strPageContent
'Write text blob to table memo field...
MySQL = "INSERT INTO NACAsiteXML (MyXML) SELECT GetMyString() AS
String2Save;"
DoCmd.RunSQL MySQL