Note: @alexnajm reply might have solved your solution by providing several API links. I didn't see them until I refreshed.
This is a topic where there are many commercial solutions out there and then "free tiers" for the big players like Google. It's not a topic that just has an easy free solution all the time, but it's one that you can normally find a solution that works. It will most likely require development from you to get a solution working, but there is tons of info out there that we can point you to.
This will go a lot quicker with the following information.
- You tried geocoder macro and it worked for one week.
- What macro was this?
- Can you provide the link ideally, or at least a name? I've seen up to 10 different geocoder macros on the community over the years.
- What is error code 9? Have you got a screenshot, or more info?
- What country are you trying to geocode?
- The Street Geocoder in the Location Insights pack only works for certain countries I think. And you would need different subscriptions if you were trying to geocode addresses on different continents.
- This is something that is relevant in APAC at least, as different countries use very different address formats and sometimes there is good in country solutions.
- What quantity of data are we talking about here?
- Will it fit into a free tier, or are we talking about 100,000 addresses
- If it's only a couple hundred then there are multiple ways. I've previously got the lat/long of a couple hundred residential addresses by using the download tool to search them on a real estate site and ripping the webpage for the lat/long. I wouldn't advise needing that in 2025, but it's an example of going a different way.
- Do you want something that can geocode once? Or do you plan to set it up to geocode new addresses every day/week?
