Rate Retrieval Tool Broke?

[Rick-O-Shay]

Hi,

I have this handy tool that will go to a website, fetch some interest rate and throw it into excel. It has worked great for a couple of years; however, as of yesterday the tool now errors with "Permission to Use Object Denied". I have no clue what the issue is.... It's a VBA code to just fetch a table from the site. Can someone please help me? Attached is the template.

[cubangt]

have you tried to visit the link its trying to get the data from?

https://apps.newyorkfed.org/markets/autorates/sofr

Has that table changed?

Also google that error, seems that it may be a pc/workstation permissions error..

https://stackoverflow.com/questions/...-to-use-object

[Rick-O-Shay]

I did, the site works and also, I have tried using the macro in some different PC environments, all still show the same error. This does not make sense because nothing has changed so I am having a hard time troubleshooting... Any other help?

The site seems to redirect to the URL: https://www.newyorkfed.org/markets/reference-rates/sofr but I updated that link in a test... same issue

[cubangt]

When debugging, the error is occuring at this portion of the code:

Please Login or Register  to view this content.

I changed this line and it ran without the error, but nothing was populated

'Set xmlHTTPReq = CreateObject("MSXML2.XMLHTTP")
Set xmlHTTPReq = CreateObject("MSXML2.ServerXMLHTTP.6.0")

[Rick-O-Shay]

Thanks... this is super weird because I have other tabs in my original file that do the same thing and all work just fine (attached). What would change about the SOFR rate tab?

[cubangt]

Not sure i can be more help, i havent worked with webpages within any of my VBA code, but have developed other code in other languages and thought i would assist where i could.

[Rick-O-Shay]

No problem, I appreciate it. I actually think I may have figured it out. The website had a change in how the data is displayed and it is not a typical embedded table in the HTML so it would not show anymore. I have it set to the new path (an XML file) https://markets.newyorkfed.org/read?...:-1&format=xml

This displays the data I need.

Thanks again for the help!

[cubangt]

Nice, glad you figured it out..