How can I automatically search for country flag symbols and import them into
excel

1. Open a new Excel worksheet and select the cell where you want to import the flag symbol.
2. In the formula bar, type "=WEBSERVICE" and then the URL of a website that provides flag images. For example, you can use the following URL: "https://www.countryflags.io/".
3. After the URL, add the two-letter country code for the country whose flag you want to import. For example, if you want to import the flag of the United States, you would add "us.png" to the end of the URL.
4. Press Enter to run the formula. The flag image should appear in the cell.
5. If the image appears as a string of text, you may need to change the cell formatting to "Picture" or "General". To do this, right-click on the cell and select "Format Cells". In the "Number" tab, select "Picture" or "General" from the Category list.
6. To import flags for multiple countries, you can use the "CONCATENATE" function to combine the URL and country codes. For example, if you have a list of country codes in column A, you can use the following formula in column B: "=WEBSERVICE(CONCATENATE("https://www.countryflags.io/",A1,".png"))". Then, copy the formula down the column to import flags for all the countries in the list.

Note that this method may not work if the website providing the flag images changes its URL structure or if the website is unavailable.

Have a look at Debbie's site http://www.contextures.com/excelfilesRon.html
Locate the link "Show pictures from a folder"
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Eckart" wrote in message
...
How can I automatically search for country flag symbols and import them
into
excel

Search where?

Go to this site and copy the entire frame of flags to Excel.

http://www.photius.com/flags/alphabetic_list.html


Gord Dibben MS Excel MVP


On Fri, 19 Jun 2009 03:28:06 -0700, Eckart
wrote:

How can I automatically search for country flag symbols and import them into
excel