Hi! I've posted here many times and have received excellent help not to mention learned a lot from all of you. I have run into a huge problem that is practically making me cry.
Since 2002 I have been running a fantasy football game using only Excel. One nice fellow helped me build a series of macros that actually goes out on the Internet with a web query, and parces out unnecessary HTLM and downloads specific data to a worksheet. It has worked fantastically since 2002 although it did take a good 40+ hours to construct.
My problem is - When the macro starts it is suppose to goe to the specific web site and retrieves the data. It doesn't do that. I am getting an erro like this:
Run-time error '-2146697208 (800c0008):
The download of the specified resource has failed.
When I try and debug the error it stops at this:
xmlhttp.Open "GET", "http://www.nfl.com/scores/2005/week" & MyWeek, False
xmlhttp.Send
The part in bold is the error. I can not figure out why it is doing it. Yes I realize I have entered 2005. I am just testing the macro using 2005 data to see if it still works. AND I tried this a week or so ago and had NO errors. Today I have an error. I have multiple copies of the macro and have checked other versions. Nothing has changed with the macro. Please keep in mind this is a big macro and I only posted a small portion of it.
Could someone please tell me what xmlhtt.send means? And what are the possible reasons for it to not work now?
I am more than willing to send the spreadsheet to anyone who dares to tackle my problem.
Thanks for the help. I am extremely upset that all my time over the years may now be for nothing.
Bill
Since 2002 I have been running a fantasy football game using only Excel. One nice fellow helped me build a series of macros that actually goes out on the Internet with a web query, and parces out unnecessary HTLM and downloads specific data to a worksheet. It has worked fantastically since 2002 although it did take a good 40+ hours to construct.
My problem is - When the macro starts it is suppose to goe to the specific web site and retrieves the data. It doesn't do that. I am getting an erro like this:
Run-time error '-2146697208 (800c0008):
The download of the specified resource has failed.
When I try and debug the error it stops at this:
xmlhttp.Open "GET", "http://www.nfl.com/scores/2005/week" & MyWeek, False
xmlhttp.Send
The part in bold is the error. I can not figure out why it is doing it. Yes I realize I have entered 2005. I am just testing the macro using 2005 data to see if it still works. AND I tried this a week or so ago and had NO errors. Today I have an error. I have multiple copies of the macro and have checked other versions. Nothing has changed with the macro. Please keep in mind this is a big macro and I only posted a small portion of it.
Could someone please tell me what xmlhtt.send means? And what are the possible reasons for it to not work now?
I am more than willing to send the spreadsheet to anyone who dares to tackle my problem.
Thanks for the help. I am extremely upset that all my time over the years may now be for nothing.
Bill