Need help with Get External Data function

[ExcelArtist]

Hello,

I would like to be able to pull the spot price of gold and silver from the internet and put them in a spreadsheet at the click of a button. I know I need to use the "Get External Data" function and / or VBA to do this. I do not know how to write Web Queries. Can someone help me out? Thanks in advance.

I am running Excel 2011 for Mac

 

[Jim Gordon]

Get External Data is for SQL queries from data stored in tables. That’s not what you are describing. What you have described is a web query. For Microsoft’s instructions on how to build web queries click here. For a tutorial I wrote on how to make web queries click here.