Look up company name in cell and return address from google using API

Hi all,

I am trying to use a code I found online to look up a company name from a cell in my excel workbook and return the address of that company from the google search result. I have obtained a google API key but the code is getting stuck on the first line:

Please Login or Register  to view this content.

If I comment out that line of code it errors on the next one. I'm not at all familiar with this type of code so I'm not even sure where to begin. Any help greatly appreciated.

Thank you.

You are using a number of data types that are not built into VBA. You will have to set a reference for those. Have you done that? From the VBA development window:

• Tools
• References
• Find "Microsoft XML, v 6.0" and check the box

This a sub but the Sub declaration is missing from your code. Can you provide the first line of code? It starts with Private Sub, Public Sub, or just Sub.

Please Login or Register  to view this content.

The variable output is not declared, and it is never given a value. This is not the only problem but I saw this right away. I am going to see if I can run your code.

Please Login or Register  to view this content.

This will hide all errors. You don't want to use this unless you have something very specific in mind that you are trying to manage.

The code has the comment

Please Login or Register  to view this content.

but you did not not replace spaces with +.

Please Login or Register  to view this content.

I got an error on the following line but I am not familiar with the object structure so I am a bit stuck:

Please Login or Register  to view this content.

However, I tried putting your query directly into a web query and got this response:

Please Login or Register  to view this content.

This suggests that your API key is not properly registered, or billing is not set up for it.