Here's the problem I'm having I want to pull web queries for a specific data table for a list of APN# Which is in column C under the tab I labeled "Orange"
for example
APN
29621305
12341234
23454322
The url which i am trying to pull data from is static with the exception of the "29621305" which is in 2 parts of the URL
http://tax.ocgov.com/tcweb/detail_sec.asp?ReqParcel=29621305&StreetNo=&Direction=&StreetName=&APN=29621305&Suffix=00&CmpRevDte=79889283&RollTypCde=Secured&Code=A&StSuffix=&City=&Unit=&s=1&p=1&t=&TaxYr=2011
I know i need a macro and my problem is very similar to this post :
http://www.mrexcel.com/forum/showthread.php?t=490865
I want the queries to populate under a separate sheet. I am trying to learn a little about macros so if anyone post a solution could you maybe highlight the variable portions. I need to do this for a few of the tabs.
Thanks
for example
APN
29621305
12341234
23454322
The url which i am trying to pull data from is static with the exception of the "29621305" which is in 2 parts of the URL
http://tax.ocgov.com/tcweb/detail_sec.asp?ReqParcel=29621305&StreetNo=&Direction=&StreetName=&APN=29621305&Suffix=00&CmpRevDte=79889283&RollTypCde=Secured&Code=A&StSuffix=&City=&Unit=&s=1&p=1&t=&TaxYr=2011
I know i need a macro and my problem is very similar to this post :
http://www.mrexcel.com/forum/showthread.php?t=490865
I want the queries to populate under a separate sheet. I am trying to learn a little about macros so if anyone post a solution could you maybe highlight the variable portions. I need to do this for a few of the tabs.
Thanks