Need help Macro download error - expert needed badly

easybpw

Active Member
Joined
Sep 30, 2003
Messages
409
Office Version
  1. 365
  2. 2013
Platform
  1. Windows
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
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

BrianB

Well-known Member
Joined
Feb 17, 2003
Messages
8,127
Don't know really.

I guess you need to look for lines of code that say
Dim xmlhttp = (something)
Set xmlhttp = (something)

and investigate the object metioned.
 
L

Legacy 98055

Guest
Go ahead and send the workbook. Automating web queries are wonderful until the web page or URL changes. :) It is probably not a big deal. See email link below...
 

Forum statistics

Threads
1,137,300
Messages
5,680,699
Members
419,928
Latest member
dolincasting

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top