A partir du non d'un pays (Par exemple le pays: la France), je cherche un scripte qui me permet de localiser la ligne qui porte le nom du pays recherché pour extraire l’indicatif de ce pays (33) qui se trouve sur une liste des pays du monde ci-dessous ou un autre moyen plus simple pour connaitre l'indicatif téléphonique du pays recherché :
Merci infiniment pour votre aide.
Cordialement.
"Albania" & "_" & "AL" & "_" & "ALB" & "_" & "355", _
"Algeria" & "_" & "DZ" & "_" & "DZA" & "_" & "213", _
"American Samoa" & "_" & "AS" & "_" & "ASM" & "_" & "1684", _
"Andorra" & "_" & "AD" & "_" & "AND" & "_" & "376", _
"Angola" & "_" & "AO" & "_" & "AGO" & "_" & "244", _
"Anguilla" & "_" & "AI" & "_" & "AIA" & "_" & "1 264", _
"Antarctica" & "_" & "AQ" & "_" & "ATA" & "_" & "672", _
"Argentina" & "_" & "AR" & "_" & "ARG" & "_" & "54", _
"Armenia" & "_" & "AM" & "_" & "ARM" & "_" & "374", _
"Aruba" & "_" & "AW" & "_" & "ABW" & "_" & "297", _
"Australia" & "_" & "AU" & "_" & "AUS" & "_" & "61", _
"Austria" & "_" & "AT" & "_" & "AUT" & "_" & "43", _
"Azerbaija" & "_" & "AZ" & "_" & "AZE" & "_" & "994", _
"Bahamas" & "_" & "BS" & "_" & "BHS" & "_" & "1", _
"Bahrai" & "_" & "BH" & "_" & "BHR" & "_" & "973", _
"Bangladesh" & "_" & "BD" & "_" & "BGD" & "_" & "880", _
"Barbados" & "_" & "BB" & "_" & "BRB" & "_" & "1", _
"Belarus" & "_" & "BY" & "_" & "BLR" & "_" & "375", _
"Belgium" & "_" & "BE" & "_" & "BEL" & "_" & "32", _
"Belize" & "_" & "BZ" & "_" & "BLZ" & "_" & "501", _
"Beni" & "_" & "BJ" & "_" & "BE" & "_" & "229", _
"Bermuda" & "_" & "BM" & "_" & "BMU" & "_" & "1", _
"Bhuta" & "_" & "BT" & "_" & "BT" & "_" & "975", _
"Bolivia" & "_" & "BO" & "_" & "BOL" & "_" & "591", _
"Bosnia and Herzegovina" & "_" & "BA" & "_" & "BIH" & "_" & "387", _
"Botswana" & "_" & "BW" & "_" & "BWA" & "_" & "267", _
"Brazil" & "_" & "BR" & "_" & "BRA" & "_" & "55", _
"British Virgin Islands" & "_" & "VG" & "_" & "VGB" & "_" & "1284", _
"Brunei" & "_" & "B" & "_" & "BR" & "_" & "673", _
"Bulgaria" & "_" & "BG" & "_" & "BGR" & "_" & "359", _
"Burkina Faso" & "_" & "BF" & "_" & "BFA" & "_" & "226", _
"Burundi" & "_" & "BI" & "_" & "BDI" & "_" & "257", _
"Cambodia" & "_" & "KH" & "_" & "KHM" & "_" & "855", _
"Cameroo" & "_" & "CM" & "_" & "CMR" & "_" & "237", _
"Canada" & "_" & "CA" & "_" & "CA" & "_" & "1", _
"Cape Verde" & "_" & "CV" & "_" & "CPV" & "_" & "238", _
"Cayman Islands" & "_" & "KY" & "_" & "CYM" & "_" & "344", _
"Central African Republic" & "_" & "CF" & "_" & "CAF" & "_" & "236", _
"Chile" & "_" & "CL" & "_" & "CHL" & "_" & "56", _
"China" & "_" & "C" & "_" & "CH" & "_" & "86", _
"Colombia" & "_" & "CO" & "_" & "COL" & "_" & "57", _
"Comoros" & "_" & "KM" & "_" & "COM" & "_" & "269", _
"Cook Islands" & "_" & "CK" & "_" & "COK" & "_" & "682", _
"Costa Rica" & "_" & "CR" & "_" & "CRI" & "_" & "506", _
"Croatia" & "_" & "HR" & "_" & "HRV" & "_" & "385", _
"Cuba" & "_" & "CU" & "_" & "CUB" & "_" & "53", _
"Curacao" & "_" & "CW" & "_" & "CUW" & "_" & "599", _
"Cyprus" & "_" & "CY" & "_" & "CYP" & "_" & "357", _
"Czech Republic" & "_" & "CZ" & "_" & "CZE" & "_" & "420", _
"Democratic Republic of Congo" & "_" & "CD" & "_" & "COD" & "_" & "243", _
"Denmark" & "_" & "DK" & "_" & "DNK" & "_" & "45", _
"Djibouti" & "_" & "DJ" & "_" & "DJI" & "_" & "253", _
"Dominica" & "_" & "DM" & "_" & "DMA" & "_" & "1", _
"Dominican Republic" & "_" & "DO" & "_" & "DOM" & "_" & "1", _
"East Timor" & "_" & "TL" & "_" & "TLS" & "_" & "670", _
"Ecuador" & "_" & "EC" & "_" & "ECU" & "_" & "593", _
"Egypt" & "_" & "EG" & "_" & "EGY" & "_" & "20", _
"El Salvador" & "_" & "SV" & "_" & "SLV" & "_" & "503", _
"Equatorial Guinea" & "_" & "GQ" & "_" & "GNQ" & "_" & "240", _
"Eritrea" & "_" & "ER" & "_" & "ERI" & "_" & "291", _
"Estonia" & "_" & "EE" & "_" & "EST" & "_" & "372", _
"Ethiopia" & "_" & "ET" & "_" & "ETH" & "_" & "251", _
"Falkland Islands" & "_" & "FK" & "_" & "FLK" & "_" & "500", _
"Faroe Islands" & "_" & "FO" & "_" & "FRO" & "_" & "298", _
"Fiji" & "_" & "FJ" & "_" & "FJI" & "_" & "679", _
"Finland" & "_" & "FI" & "_" & "FI" & "_" & "358", _
"France" & "_" & "FR" & "_" & "FRA" & "_" & "33", _
"French Polynesia" & "_" & "PF" & "_" & "PYF" & "_" & "689", _
"Gabo" & "_" & "GA" & "_" & "GAB" & "_" & "241", _
"Gambia" & "_" & "GM" & "_" & "GMB" & "_" & "220", _
"Georgia" & "_" & "GE" & "_" & "GEO" & "_" & "995", _
"Germany" & "_" & "DE" & "_" & "DEU" & "_" & "49", _
"Ghana" & "_" & "GH" & "_" & "GHA" & "_" & "233", _
"Gibraltar" & "_" & "GI" & "_" & "GIB" & "_" & "350", _
"Greece" & "_" & "GR" & "_" & "GRC" & "_" & "30", _
"Greenland" & "_" & "GL" & "_" & "GRL" & "_" & "299", _
"Guadeloupe" & "_" & "GP" & "_" & "GLP" & "_" & "590", _
"Guam" & "_" & "GU" & "_" & "GUM" & "_" & "1 671", _
"Guatemala" & "_" & "GT" & "_" & "GTM" & "_" & "502", _
"Guinea" & "_" & "G" & "_" & "GI" & "_" & "224", _
"Guinea-Bissau" & "_" & "GW" & "_" & "GNB" & "_" & "245", _
"Guyana" & "_" & "GY" & "_" & "GUY" & "_" & "592", _
"Haiti" & "_" & "HT" & "_" & "HTI" & "_" & "509", _
"Honduras" & "_" & "H" & "_" & "HND" & "_" & "504", _
"Hong Kong" & "_" & "HK" & "_" & "HKG" & "_" & "852", _
"Hungary" & "_" & "HU" & "_" & "HU" & "_" & "36", _
"Iceland" & "_" & "IS" & "_" & "ISL" & "_" & "354", _
"India" & "_" & "I" & "_" & "IND" & "_" & "91", _
"Indonesia" & "_" & "ID" & "_" & "ID" & "_" & "62", _
"Ira" & "_" & "IR" & "_" & "IR" & "_" & "98", _
"Iraq" & "_" & "IQ" & "_" & "IRQ" & "_" & "964", _
"Ireland" & "_" & "IE" & "_" & "IRL" & "_" & "353", _
"Isle of Ma" & "_" & "IM" & "_" & "IM" & "_" & "44", _
"Israel" & "_" & "IL" & "_" & "ISR" & "_" & "972", _
"Italy" & "_" & "IT" & "_" & "ITA" & "_" & "39", _
"Ivory Coast" & "_" & "CI" & "_" & "CIV" & "_" & "225", _
"Jamaica" & "_" & "JM" & "_" & "JAM" & "_" & "1", _
"Japa" & "_" & "JP" & "_" & "JP" & "_" & "81", _
"Jorda" & "_" & "JO" & "_" & "JOR" & "_" & "962", _
"Kazakhsta" & "_" & "KZ" & "_" & "KAZ" & "_" & "7", _
"Kenya" & "_" & "KE" & "_" & "KE" & "_" & "254", _
"Kosovo" & "_" & "XK" & "_" & "XKX" & "_" & "38", _
"Kuwait" & "_" & "KW" & "_" & "KWT" & "_" & "965", _
"Kyrgyzsta" & "_" & "KG" & "_" & "KGZ" & "_" & "996", _
"Laos" & "_" & "LA" & "_" & "LAO" & "_" & "856", _
"Latvia" & "_" & "LV" & "_" & "LVA" & "_" & "371", _
"Lebano" & "_" & "LB" & "_" & "LB" & "_" & "961", _
"Lesotho" & "_" & "LS" & "_" & "LSO" & "_" & "266", _
"Liberia" & "_" & "LR" & "_" & "LBR" & "_" & "231", _
"Libya" & "_" & "LY" & "_" & "LBY" & "_" & "218", _
"Liechtenstei" & "_" & "LI" & "_" & "LIE" & "_" & "423", _
"Lithuania" & "_" & "LT" & "_" & "LTU" & "_" & "370", _
"Luxembourg" & "_" & "LU" & "_" & "LUX" & "_" & "352", _
"Macau" & "_" & "MO" & "_" & "MAC" & "_" & "853", _
"Macedonia" & "_" & "MK" & "_" & "MKD" & "_" & "389", _
"Madagascar" & "_" & "MG" & "_" & "MDG" & "_" & "261", _
"Malawi" & "_" & "MW" & "_" & "MWI" & "_" & "265", _
"Malaysia" & "_" & "MY" & "_" & "MYS" & "_" & "60", _
"Maldives" & "_" & "MV" & "_" & "MDV" & "_" & "960", _
"Mali" & "_" & "ML" & "_" & "MLI" & "_" & "223", _
"Malta" & "_" & "MT" & "_" & "MLT" & "_" & "356", _
"Marshall Islands" & "_" & "MH" & "_" & "MHL" & "_" & "692", _
"Mauritania" & "_" & "MR" & "_" & "MRT" & "_" & "222", _
"Mauritius" & "_" & "MU" & "_" & "MUS" & "_" & "230", _
"Mexico" & "_" & "MX" & "_" & "MEX" & "_" & "52", _
"Micronesia" & "_" & "FM" & "_" & "FSM" & "_" & "691", _
"Moldova" & "_" & "MD" & "_" & "MDA" & "_" & "373", _
"Monaco" & "_" & "MC" & "_" & "MCO" & "_" & "377", _
"Mongolia" & "_" & "M" & "_" & "MNG" & "_" & "976", _
"Montenegro" & "_" & "ME" & "_" & "MNE" & "_" & "382", _
"Montserrat" & "_" & "MS" & "_" & "MSR" & "_" & "1 664", _
"Morocco" & "_" & "MA" & "_" & "MAR" & "_" & "212", _
"Mozambique" & "_" & "MZ" & "_" & "MOZ" & "_" & "258", _
"Myanmar [Burma]" & "_" & "MM" & "_" & "MMR" & "_" & "95", _
"Namibia" & "_" & "NA" & "_" & "NAM" & "_" & "264", _
"Nauru" & "_" & "NR" & "_" & "NRU" & "_" & "674", _
"Nepal" & "_" & "NP" & "_" & "NPL" & "_" & "977", _
"Netherlands" & "_" & "NL" & "_" & "NLD" & "_" & "31", _
"New Caledonia" & "_" & "NC" & "_" & "NCL" & "_" & "687", _
"New Zealand" & "_" & "NZ" & "_" & "NZL" & "_" & "64", _
"Nicaragua" & "_" & "NI" & "_" & "NIC" & "_" & "505", _
"Niger" & "_" & "NE" & "_" & "NER" & "_" & "227", _
"Nigeria" & "_" & "NG" & "_" & "NGA" & "_" & "234", _
"Niue" & "_" & "NU" & "_" & "NIU" & "_" & "683", _
"Norfolk Island" & "_" & "NF" & "_" & "NFK" & "_" & "672", _
"North Korea" & "_" & "KP" & "_" & "PRK" & "_" & "850", _
"Northern Mariana Islands" & "_" & "MP" & "_" & "MNP" & "_" & "1670", _
"Norway" & "_" & "NO" & "_" & "NOR" & "_" & "47", _
"Oma" & "_" & "OM" & "_" & "OM" & "_" & "968", _
"Pakista" & "_" & "PK" & "_" & "PAK" & "_" & "92", _
"Palau" & "_" & "PW" & "_" & "PLW" & "_" & "680", _
"Panama" & "_" & "PA" & "_" & "PA" & "_" & "507", _
"Papua New Guinea" & "_" & "PG" & "_" & "PNG" & "_" & "675", _
"Paraguay" & "_" & "PY" & "_" & "PRY" & "_" & "595", _
"Peru" & "_" & "PE" & "_" & "PER" & "_" & "51", _
"Philippines" & "_" & "PH" & "_" & "PHL" & "_" & "63", _
"Pitcairn Islands" & "_" & "P" & "_" & "PC" & "_" & "870", _
"Poland" & "_" & "PL" & "_" & "POL" & "_" & "48", _
"Portugal" & "_" & "PT" & "_" & "PRT" & "_" & "351", _
"Puerto Rico" & "_" & "PR" & "_" & "PRI" & "_" & "1", _
"Qatar" & "_" & "QA" & "_" & "QAT" & "_" & "974", _
"Republic of the Congo" & "_" & "CG" & "_" & "COG" & "_" & "242", _
"Reunio" & "_" & "RE" & "_" & "REU" & "_" & "262", _
"Romania" & "_" & "RO" & "_" & "ROU" & "_" & "40", _
"Russia" & "_" & "RU" & "_" & "RUS" & "_" & "7", _
"Rwanda" & "_" & "RW" & "_" & "RWA" & "_" & "250", _
"Saint-Barthélemy" & "_" & "BL" & "_" & "BLM" & "_" & "590", _
"Saint Helena" & "_" & "SH" & "_" & "SH" & "_" & "290", _
"Saint Kitts and Nevis" & "_" & "K" & "_" & "KNA" & "_" & "1", _
"Saint Lucia" & "_" & "LC" & "_" & "LCA" & "_" & "1", _
"Saint Marti" & "_" & "MF" & "_" & "MAF" & "_" & "1 599", _
"Saint Pierre and Miquelo" & "_" & "PM" & "_" & "SPM" & "_" & "508", _
"Saint Vincent and the Grenadines" & "_" & "VC" & "_" & "VCT" & "_" & "1", _
"Samoa" & "_" & "WS" & "_" & "WSM" & "_" & "685", _
"San Marino" & "_" & "SM" & "_" & "SMR" & "_" & "378", _
"Sao Tome and Principe" & "_" & "ST" & "_" & "STP" & "_" & "239", _
"Saudi Arabia" & "_" & "SA" & "_" & "SAU" & "_" & "966", _
"Senegal" & "_" & "S" & "_" & "SE" & "_" & "221", _
"Serbia" & "_" & "RS" & "_" & "SRB" & "_" & "381", _
"Seychelles" & "_" & "SC" & "_" & "SYC" & "_" & "248", _
"Sierra Leone" & "_" & "SL" & "_" & "SLE" & "_" & "232", _
"Singapore" & "_" & "SG" & "_" & "SGP" & "_" & "65", _
"Slovakia" & "_" & "SK" & "_" & "SVK" & "_" & "421", _
"Slovenia" & "_" & "SI" & "_" & "SV" & "_" & "386", _
"Solomon Islands" & "_" & "SB" & "_" & "SLB" & "_" & "677", _
"Somalia" & "_" & "SO" & "_" & "SOM" & "_" & "252", _
"South Africa" & "_" & "ZA" & "_" & "ZAF" & "_" & "27", _
"South Korea" & "_" & "KR" & "_" & "KOR" & "_" & "82", _
"South Suda" & "_" & "SS" & "_" & "SSD" & "_" & "211", _
"Spai" & "_" & "ES" & "_" & "ESP" & "_" & "34", _
"Sri Lanka" & "_" & "LK" & "_" & "LKA" & "_" & "94", _
"Suda" & "_" & "SD" & "_" & "SD" & "_" & "249", _
"Suriname" & "_" & "SR" & "_" & "SUR" & "_" & "597", _
"Swaziland" & "_" & "SZ" & "_" & "SWZ" & "_" & "268", _
"Swede" & "_" & "SE" & "_" & "SWE" & "_" & "46", _
"Switzerland" & "_" & "CH" & "_" & "CHE" & "_" & "41", _
"Syria" & "_" & "SY" & "_" & "SYR" & "_" & "963", _
"Taiwa" & "_" & "TW" & "_" & "TW" & "_" & "886", _
"Tajikista" & "_" & "TJ" & "_" & "TJK" & "_" & "992", _
"Tanzania" & "_" & "TZ" & "_" & "TZA" & "_" & "255", _
"Thailand" & "_" & "TH" & "_" & "THA" & "_" & "66", _
"Togo" & "_" & "TG" & "_" & "TGO" & "_" & "228", _
"Tokelau" & "_" & "TK" & "_" & "TKL" & "_" & "690", _
"Trinidad and Tobago" & "_" & "TT" & "_" & "TTO" & "_" & "1", _
"Tunisia" & "_" & "T" & "_" & "TU" & "_" & "216", _
"Turkey" & "_" & "TR" & "_" & "TUR" & "_" & "90", _
"Turkmenista" & "_" & "TM" & "_" & "TKM" & "_" & "993", _
"Tuvalu" & "_" & "TV" & "_" & "TUV" & "_" & "688", _
"Uganda" & "_" & "UG" & "_" & "UGA" & "_" & "256", _
"Ukraine" & "_" & "UA" & "_" & "UKR" & "_" & "380", _
"United Arab Emirates" & "_" & "AE" & "_" & "ARE" & "_" & "971", _
"United Kingdom" & "_" & "GB" & "_" & "GBR" & "_" & "44", _
"United States" & "_" & "US" & "_" & "USA" & "_" & "1", _
"Uruguay" & "_" & "UY" & "_" & "URY" & "_" & "598", _
"Uzbekista" & "_" & "UZ" & "_" & "UZB" & "_" & "998", _
"Vanuatu" & "_" & "VU" & "_" & "VUT" & "_" & "678", _
"Vatica" & "_" & "VA" & "_" & "VAT" & "_" & "39", _
"Venezuela" & "_" & "VE" & "_" & "VE" & "_" & "58", _
"Vietnam" & "_" & "V" & "_" & "VNM" & "_" & "84", _
"Western Sahara" & "_" & "EH" & "_" & "ESH" & "_" & "212", _
"Yeme" & "_" & "YE" & "_" & "YEM" & "_" & "967", _
"Zambia" & "_" & "ZM" & "_" & "ZMB" & "_" & "260", _
"Zimbabwe" & "_" & "ZW" & "_" & "ZWE" & "_" & "263"]