VBA Code not working anymore to collect data from Coinmarketcap

[Rudidw]

Hi,

I recieved code from one of the forum users a little while back that worked great but over the last month or so the code keeps giving an error.

The attached code collects data from Coin Market Cap and places it in a "Temp" sheet but it does not run anymore for some reason.

Would really appreciate it if someone could get the code working again

Here is the code:

Please Login or Register  to view this content.

[6StringJazzer]

the code keeps giving an error.

When asking for help with an error, always tell us what the error is.

[6StringJazzer]

When I enter your URL into a browser I get this message. You are using an obsolete API.

{"statusCode": 410,"error": "Gone","message": "WARNING: This API is now offline. Please switch to the new CoinMarketCap API. (https://pro.coinmarketcap.com/migrate/)"}

[Rudidw]

Apologies! I get the following error:

Runtime error 5

Invalid procedure call or argument

When I click on debug it highlights this piece of the code-

Please Login or Register  to view this content.

Also see image attachedAttachment 669768

[Rudidw]

Thank you yes I believe that was the problem.

I was able to get my workbook working again by following the instructions on this page:
https://medium.com/@moralesgersonpa/...p-49759f10a69d

Thanks for the help