Windows 7, Excel 2007
Trying to retrieve information from website that requires drop-down boxes to be selected and information entered. Then website returns answer in another webpage with a URL that is always the same and is not accessible by a web browser. Here is the URL that shows on the webpage with the answer.
<table style="width: 380px; height: 42px;" border="0" cellpadding="0" cellspacing="0"><tbody><tr height="19"><td class="xl65" style="height:14.4pt;width:48pt" height="19" width="64"><table border="0" cellpadding="0" cellspacing="0" width="64"><tbody><tr height="19"><td class="xl65" style="height:14.4pt;width:48pt" height="19" width="64">https://apps1.coned.com/CSOL/MSC_Process_CC.asp</td> </tr></tbody></table></td></tr></tbody></table>
I'm trying to get the answer to show up on a worksheet in Excel. I do not think this is a web query. I wrote a VBA macro that opens the website, fills in the information and selects the drop-down entry and returns the answer in another webpage with the address above but I cannot figure out how to get the answer from this URL that you cannot access from a browser into my worksheet. Any thoughts?
Here is where the form is:
https://apps1.coned.com/csol/msc_cc.asp
Trying to retrieve information from website that requires drop-down boxes to be selected and information entered. Then website returns answer in another webpage with a URL that is always the same and is not accessible by a web browser. Here is the URL that shows on the webpage with the answer.
<table style="width: 380px; height: 42px;" border="0" cellpadding="0" cellspacing="0"><tbody><tr height="19"><td class="xl65" style="height:14.4pt;width:48pt" height="19" width="64"><table border="0" cellpadding="0" cellspacing="0" width="64"><tbody><tr height="19"><td class="xl65" style="height:14.4pt;width:48pt" height="19" width="64">https://apps1.coned.com/CSOL/MSC_Process_CC.asp</td> </tr></tbody></table></td></tr></tbody></table>
I'm trying to get the answer to show up on a worksheet in Excel. I do not think this is a web query. I wrote a VBA macro that opens the website, fills in the information and selects the drop-down entry and returns the answer in another webpage with the address above but I cannot figure out how to get the answer from this URL that you cannot access from a browser into my worksheet. Any thoughts?
Here is where the form is:
https://apps1.coned.com/csol/msc_cc.asp
