{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["ACCUEIL","HISTORIQUE","DATAS","Feuil1","RECAPITULATIF","Bon de commande- Fra","Recapitulatif commande","Base fournisseur","Base entreprise"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":1,"defined_names":111,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"ACCUEIL","index":0,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,1],[10,1,10,10]]}
[41981.774837962963]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"FORMULAIRE DE COMMANDE POUR DES ACHATS HORS PRODUCTION"]

{"sheet":"HISTORIQUE","index":1,"n_rows":4,"n_cols":17,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["NUMERO DE COMMANDE","TRIGRAMME","DATE DE LA COMMANDE","DEPARTEMENT","DESIGNATION ARTICLE A COMMANDER","FOURNISSEUR","REFERENCE DEVIS","REFERENCE ARTICLE","DATE LIVRAISON SOUHAITEE","QUANTITE","PRIX","DEVISE","TOTAL","DIVISION","CAD","COMPTE IMPUTATION","COMPTE PROJET"]
["CAHP- 15- 0001","ABE","16 janvier 2015","Back Office","ggfd","Fournisseur 3","","","05 octobre 2015",150,2,"EUR",300,"100 - Dentaire","1000 Finances","300000 Purchase material","481010 abc"]
["CAHP- 15- 0002","ABE","16 janvier 2015","After Sales VU","fgsd","Fournisseur 2","gfd","gdf","05 février 2015",152,6,"EUR",912,"100 - Dentaire","1000 Finances","300000 Purchase material","481010 abc"]
["CAHP- 15- 0003","ABE","17 janvier 2015","Customer Service VU","FVEfEFVE","Fournisseur 3","gzVz","ffaF","01 février 2015",10,10,"EUR",100,"200 - Médical","1100 Logistique CC18","306000 purchasing expenses.","481040 fds"]

{"sheet":"DATAS","index":2,"n_rows":183,"n_cols":28,"rows_kept":183,"cut":false,"hidden":false,"merged":[]}
["DEPARTEMENT",null,null,null,"DIVISION",null,"CDA",null,"COMPTE IMPUTATION",null,"COMPTE PROJET",null,"DEVISE",null,null,"PAYS","INDICATIF",null,"ADRESSE INTERNE","CODE POSTAL INTERNE","VILLE INTERNE","PAYS INTERNE",null,null,"NR","MP",null,"mppm"]
["After Sales VU",null,null,null,"000 - Service",null,"1000 Finances",null,"300000 Purchase material",null,"481010 abc",null,"CHF","CHF",null,"Suisse","+41(0)",null,"Chemin du travail",1234,"Ici","Belgique",null,null,"DURAND","D1234"]
["Back Office",null,null,null,"100 - Dentaire",null,"1100 Logistique CC18",null,"300010 credit note",null,"481030 jkf",null,"EUR","€",null,"France","+33(0)",null,"Champ 18",5678,"labas","France",null,null,"LEON","456A"]
["Customer Service VU",null,null,null,"200 - Médical",null,"1200 IT",null,"306000 purchasing expenses.",null,"481040 fds",null,"USD","$",null,"Allemagne","+49(0)",null,"Champ 06",null,null,null,null,null,"MERLIN","987ML"]
[null,null,null,null,null,null,null,null,null,null,null,null,"GBP","£",null,"Etats-Unis","+1(0)",null,"132 Route demachin"]
[null,null,null,null,null,null,null,null,null,null,null,null,"  -------",null,null,"Royaume-Uni","+44(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"AED",null,null,"  -------------------------------------","  -------"]
[null,null,null,null,null,null,null,null,null,null,null,null,"AFN",null,null,"Afghanistan"," +93(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ALL",null,null,"Afrique du Sud","+27(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"AMD",null,null,"Albanie"," +355(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ANG",null,null,"Algérie","+213(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"AOA",null,null,"Angola","+244(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ARS",null,null,"Arabie saoudite","+966(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"AUD",null,null,"Argentine","+54(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"AWG",null,null,"Arménie","+374(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"AZN",null,null,"Australie","+61(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"BAM",null,null,"Autriche","+43(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"BBD",null,null,"Azerbaïdjan"," +994(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"BDT",null,null,"Bahamas","+1242(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"BGN",null,null,"Bahreïn","+973(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"BHD",null,null,"Bangladesh","+880(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"BIF",null,null,"Belgique","+32(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"BMD",null,null,"Bélize","+501(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"BND",null,null,"Bénin","+229(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"BOB",null,null,"Bhoutan","+975(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"BOV",null,null,"Biélorussie","+375(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"BRL",null,null,"Birmanie"," +95(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"BSD",null,null,"Bolivie","+591(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"BTN",null,null,"Bosnie","+387(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"BWP",null,null,"Botswana","+267(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"BYR",null,null,"Brésil","+55(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"BZD",null,null,"Brunei","+673(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CAD",null,null,"Bulgarie","+359(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CDF",null,null,"Burkina Faso","+226(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CHE",null,null,"Burundi","+257(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CHW",null,null,"Cambodge","+855(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CLF",null,null,"Cameroun","+237(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CLP",null,null,"Canada","+1(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CNH",null,null,"Cap-Vert","+238(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CNY",null,null,"Chili","+56(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"COP",null,null,"Chine","+86(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"COU",null,null,"Colombie","+57(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CRC",null,null,"Comores","+269(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CUC",null,null,"Corée-du-Nord","+850(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CUP",null,null,"Corée-du-Sud","+82(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CVE",null,null,"Côte d'Ivoire","+225(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CZK",null,null,"Croatie","+385(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"DJF",null,null,"Cuba","+53(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"DKK",null,null,"Danemark","+45(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"DOP",null,null,"Djibouti","+253(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"DZD",null,null,"Dominique","+1767(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"EGP",null,null,"Ecosse"," +44(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ERN",null,null,"Egypte","+20(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ETB",null,null,"Emirats arabes unis","+971(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"FJD",null,null,"Equateur","+593(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"FKP",null,null,"Erythrée","+291(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"GEL",null,null,"Espagne","+34(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"GHS",null,null,"Estonie"," +372(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"GIP",null,null,"Ethiopie","+251(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"GMD",null,null,"Fidji","+679(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"GNF",null,null,"Finlande","+358(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"GTQ",null,null,"Gabon","+241(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"GYD",null,null,"Gambie","+220(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"HKD",null,null,"Géorgie","+995(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"HNL",null,null,"Ghana","+233(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"HRK",null,null,"Grèce"," +30(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"HTG",null,null,"Grenade"," +1473(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"HUF",null,null,"Guatemala","+502(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"IDR",null,null,"Guinée-équatoriale","+240(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ILS",null,null,"Guinée","+224(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"INR",null,null,"Guinée-Bissao"," +245(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"IQD",null,null,"Guyana","+592(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"IRR",null,null,"Haïti","+509(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ISK",null,null,"Honduras","+504(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"JMD",null,null,"Hongrie","+36(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"JOD",null,null,"Inde","+91(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"JPY",null,null,"Indonésie","+62(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"KES",null,null,"Irak","+964(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"KGS",null,null,"Iran","+98(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"KHR",null,null,"Irlande","+353(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"KMF",null,null,"Islande","+354(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"KPW",null,null,"Israël"," +972(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"KRW",null,null,"Italie","+39(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"KWD",null,null,"Jamaïque"," +1876(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"KYD",null,null,"Japon","+81(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"KZT",null,null,"Jordanie","+962(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"LAK",null,null,"Kazakhstan"," +7(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"LBP",null,null,"Kenya"," +254(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"LKR",null,null,"Kirghizistan"," +996(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"LRD",null,null,"Kiribati","+686(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"LSL",null,null,"Koweït"," +965(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"LTL",null,null,"Laos","+856(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"LYD",null,null,"Lettonie","+371(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MAD",null,null,"Liban","+961(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MDL",null,null,"Liberia"," +231(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MGA",null,null,"Libye","+218(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MKD",null,null,"Liechtenstein","+423(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MMK",null,null,"Lituanie","+370(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MNT",null,null,"Luxembourg","+352(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MOP",null,null,"Macédoine","+389(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MRO",null,null,"Madagascar","+261(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MUR",null,null,"Malaisie","+60(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MVR",null,null,"Malawi","+265(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MWK",null,null,"Maldives","+960(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MXN",null,null,"Mali","+223(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MXV",null,null,"Malte","+356(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MYR",null,null,"Maroc","+212(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MZN",null,null,"Maurice"," +230(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"NAD",null,null,"Mauritanie","+222(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"NGN",null,null,"Mexique"," +52(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"NIO",null,null,"Micronésie","+691(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"NOK",null,null,"Moldavie","+373(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"NPR",null,null,"Monaco","+377(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"NZD",null,null,"Mongolie","+976(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"OMR",null,null,"Mozambique","+258(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"PAB",null,null,"Namibie","+264(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"PEN",null,null,"Nauru","+674(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"PGK",null,null,"Népal","+977(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"PHP",null,null,"Nicaragua","+505(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"PKR",null,null,"Niger","+227(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"PLN",null,null,"Nigeria"," +234 (0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"PYG",null,null,"Norvège","+47(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"QAR",null,null,"Nouvelle-Zélande","+64(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"RON",null,null,"Oman","+968(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"RSD",null,null,"Ouganda","+256(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"RUB",null,null,"Ouzbékistan"," +998(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"RWF",null,null,"Pakistan","+92(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SAR",null,null,"Palestine"," +970(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SBD",null,null,"Panama","+507(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SCR",null,null,"Papouasie-Nouvelle-Guinée","+675(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SDG",null,null,"Paraguay","+595(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SEK",null,null,"Pays-Bas","+31(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SGD",null,null,"Pérou","+51(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SHP",null,null,"Philippines","+63(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SLL",null,null,"Pologne","+48(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SOS",null,null,"Portugal","+351(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SRD",null,null,"Qatar","+974(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SSP",null,null,"République démocratique du Congo","+243(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"STD",null,null,"République tchèque"," +420(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SYP",null,null,"Roumanie","+40(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SZL",null,null,"Russie","+7(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"THB",null,null,"Rwanda","+250(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TJS",null,null,"Salvador"," +503(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TMT",null,null,"Sénégal","+221(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TND",null,null,"Seychelles","+248(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TOP",null,null,"Sierra-Leone"," +232(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TRY",null,null,"Singapour","+65(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TTD",null,null,"Slovaquie","+421(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TWD",null,null,"Slovénie","+386(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TZS",null,null,"Somalie","+252(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"UAH",null,null,"Soudan","+249(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"UGX",null,null,"Sri-Lanka"," +94(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"USN",null,null,"Suède","+46(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"USS",null,null,"Suriname"," +597(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"UYI",null,null,"Swaziland","+268(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"UYU",null,null,"Syrie","+963(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"UZS",null,null,"Tadjikistan"," +992(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"VEF",null,null,"Tanzanie","+255(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"VND",null,null,"Tchad","+235(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"VUV",null,null,"Thaïlande"," +66(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WST",null,null,"Togo","+228(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"XAF",null,null,"Tonga","+676(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"XAG",null,null,"Tunisie","+216(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"XAU",null,null,"Turkménistan","+993(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"XBA",null,null,"Turquie","+90(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"XBB",null,null,"Tuvalu","+688(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"XBC",null,null,"Ukraine","+380(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"XBD",null,null,"Uruguay","+598(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"XCD",null,null,"Vanuatu","+678(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"XDR",null,null,"Venezuela"," +58(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"XFU",null,null,"VietNam","+84(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"XOF",null,null,"Yémen","+967(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"XPD",null,null,"Zambie","+260(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"XPF",null,null,"Zimbabwe","+263(0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"XPT"]
[null,null,null,null,null,null,null,null,null,null,null,null,"XSU"]
[null,null,null,null,null,null,null,null,null,null,null,null,"XTS"]
[null,null,null,null,null,null,null,null,null,null,null,null,"XUA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"XXX"]
[null,null,null,null,null,null,null,null,null,null,null,null,"YER"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ZAR"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ZMW"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ZWD"]

{"sheet":"Feuil1","index":3,"n_rows":38,"n_cols":2,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Envoi mail Outlook via macro depuis un formulaire sous VBA"]
[]
[null,"Niconz - 16 janv. 2015 à 17:01"]
[null,"Ne plus suivre"]
[null,"Bonjour à tous,"]
[]
[null,"Je me permets de faire appel à votre aide pour un problème assez épineux."]
[]
[null,"J'utilise actuellement le formulaire ci-joint pour passer des commandes."]
[]
[null,"https://mon-partage.fr/f/cDlrEjhB/"]
[null,"Mdp : essai"]
[]
[null,"Lorsque vous remplissez une nouvelle commande, comme il se doit, vous avez ensuite la possiblité d'enregistrer un PDF de votre commande."]
[]
[null,"En plus de cela, je souhaiterai donner la possibilité d'envoyer ce PDF en pièce jointe d'un mail (nous utilisons Outlook), avec un texte pré-défini par défault."]
[null,"Ex :"]
[null,"Bonjour,"]
[null,"Veuillez trouver ci-joint notre commande...blabla"]
[null,"Vous en souhaitant bonne réception,"]
[null,"Cordialement,"]
[]
[null,"L'adresse mail du fournisseur est caché dans l'onglet « Base fournisseur », mais elle n'apparait pas dans la commande PDF."]
[]
[null,"L'envoi de ce mail avec le PDF en P.J interviendrait qu'après avoir cliqué sur un nouveau bouton « Envoyer la commande au fournisseur » qui serait sur l'UF Nouvelle commande."]
[]
[null,"Auriez-vous svp une solution à proposer ?"]
[]
[null,"D'avance, un grand merci à ceux qui pourront m'aider."]
[]
[null,"Excellent weekend,"]
[]
[null,"NicoNZ."]
[]
[]
[null,"    ThisWorkbook.Protect (Sheets(\"DATAS\").Range(\"AB2\")), UserInterfaceOnly:=True"]

{"sheet":"RECAPITULATIF","index":4,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[[19,2,19,3],[1,4,1,6],[3,1,3,2],[4,1,4,2],[4,4,4,5],[5,1,5,2],[5,4,5,5],[10,4,10,5],[11,4,11,5],[16,2,16,3],[17,2,17,3],[18,2,18,3],[31,2,31,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[30,2,30,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[35,2,35,3],[36,2,36,3]]}
[]
[null,null,null," RECAPITULATIF COMMANDE"]
[]
[null,"N° commande"]
[null,"CAHP- 15- 0049",null,"Date de la commande ",null,null," "]
[null,null,null,"Date livraison souhaitée"]
[null,"DEMANDEUR"]
[null,"Trigramme",null,"Département","Division"]
[]
[]
[null,"CDA",null,"Compte imputation","Compte Projet"]
[]
[]
[null,"FOURNISSEUR",null,null,null,"Devise"]
[null,"N° offre/devis",null,null,null,"TOTAL commande :",{"$f":"SUM(G18:G37)","v":0}]
[]
["N°","Référence","Désignation",null,"Qté","PU","Montant"]
[1,null,null,null,null,null,{"$f":"IF(F18<>\"\",E18*F18,\"\")","v":""}]
[{"$f":"IF(C19<>\"\",A18+1,\"\")","v":""},null,null,null,null,null,{"$f":"IF(F19<>\"\",E19*F19,\"\")","v":""}]
[{"$f":"IF(C20<>\"\",A19+1,\"\")","v":""},null,null,null,null,null,""]
["",null,null,null,null,null,""]
["",null,null,null,null,null,""]
["",null,null,null,null,null,""]
["",null,null,null,null,null,""]
["",null,null,null,null,null,""]
["",null,null,null,null,null,""]
["",null,null,null,null,null,""]
["",null,null,null,null,null,""]
["",null,null,null,null,null,""]
["",null,null,null,null,null,""]
["",null,null,null,null,null,""]
["",null,null,null,null,null,""]
["",null,null,null,null,null,""]
["",null,null,null,null,null,""]
["",null,null,null,null,null,""]
["",null,null,null,null,null,""]
["",null,null,null,null,null,""]

{"sheet":"Bon de commande- Fra","index":5,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[[62,0,62,10],[63,0,63,10],[54,1,54,3],[57,0,57,10],[58,0,58,10],[59,0,59,10],[60,0,60,10],[61,0,61,10],[47,3,47,6],[48,3,48,6],[49,3,49,6],[50,3,50,6],[46,3,46,6],[35,3,35,6],[36,3,36,6],[37,3,37,6],[38,3,38,6],[39,3,39,6],[30,3,30,6],[53,4,53,5],[45,3,45,6],[34,3,34,6],[4,1,4,3],[15,1,15,10],[31,3,31,6],[32,3,32,6],[33,3,33,6],[27,2,27,3],[28,2,28,3],[40,3,40,6],[41,3,41,6],[42,3,42,6],[43,3,43,6],[44,3,44,6]]}
[79]
[]
[]
[]
[]
[]
[null,{"$f":"IFERROR(VLOOKUP($E$26,BASE_ENTREPRISE,2,0)&\" \"&VLOOKUP($E$26,BASE_ENTREPRISE,3,0),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($E$26,BASE_ENTREPRISE,11,0),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($E$26,BASE_ENTREPRISE,4,0),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($E$26,BASE_ENTREPRISE,5,0)&\" \"&VLOOKUP($E$26,BASE_ENTREPRISE,6,0),\"\")","v":""}]
[]
[null,"Tel : ",{"$f":"IFERROR(VLOOKUP($E$26,BASE_ENTREPRISE,9,0),\"\")","v":""}]
[null,"Fax :",{"$f":"IFERROR(VLOOKUP($E$26,BASE_ENTREPRISE,10,0),\"\")","v":""}]
[null,"E-mail : ",{"$f":"IFERROR(VLOOKUP($E$26,BASE_ENTREPRISE,8,0),\"\")","v":""}]
[]
[null,"BON DE COMMANDE\n"]
[]
[null,null,null,null,null,null,{"$f":"'Recapitulatif commande'!D14","v":0}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($G$18,BASE_FOURNISSEUR,4,0),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($G$18,BASE_FOURNISSEUR,5,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($G$18,BASE_FOURNISSEUR,6,0),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($G$18,BASE_FOURNISSEUR,7,0),\"\")","v":""}]
[]
[null,null,null,null,null,null,"N° de Fax : ",{"$f":"IFERROR(VLOOKUP($G$18,BASE_FOURNISSEUR,9,0),\"\")","v":""}]
[]
[]
[null,null,"                       Commande N°",{"$f":"'Recapitulatif commande'!D4","v":0},{"$f":"'Recapitulatif commande'!B9","v":0},{"$f":"'Recapitulatif commande'!D9","v":0},null," ◄ N° de commande à faire figurer impérativement sur votre facture !"]
[]
[null,null,"Offre N°:",null,{"$f":"'Recapitulatif commande'!D15","v":0}]
[null,null,"Date commande:",null,{"$f":"'Recapitulatif commande'!E5:F5","v":0}]
[]
[null,"N°","Référence","Désignation",null,null,null,"Quantité","Prix Unitaire","Prix Total HT","Devise"]
[null,1,{"$f":"'Recapitulatif commande'!B18","v":0},{"$f":"IF('Recapitulatif commande'!C18=\"\",\"\",'Recapitulatif commande'!C18)","v":""},null,null,null,{"$f":"'Recapitulatif commande'!E18","v":0},{"$f":"'Recapitulatif commande'!F18","v":0},{"$f":"'Recapitulatif commande'!G18","v":""},{"$f":"IF(J32=\"\",\"\",'Recapitulatif commande'!$G$14 &\" HT\")","v":""}]
[null,2,{"$f":"'Recapitulatif commande'!B19","v":0},{"$f":"IF('Recapitulatif commande'!C19=\"\",\"\",'Recapitulatif commande'!C19)","v":""},null,null,null,{"$f":"'Recapitulatif commande'!E19","v":0},{"$f":"'Recapitulatif commande'!F19","v":0},{"$f":"'Recapitulatif commande'!G19","v":""},{"$f":"IF(J33=\"\",\"\",'Recapitulatif commande'!$G$14 &\" HT\")","v":""}]
[null,3,{"$f":"'Recapitulatif commande'!B20","v":0},{"$f":"IF('Recapitulatif commande'!C20=\"\",\"\",'Recapitulatif commande'!C20)","v":""},null,null,null,{"$f":"'Recapitulatif commande'!E20","v":0},{"$f":"'Recapitulatif commande'!F20","v":0},{"$f":"'Recapitulatif commande'!G20","v":""},{"$f":"IF(J34=\"\",\"\",'Recapitulatif commande'!$G$14 &\" HT\")","v":""}]
[null,4,{"$f":"'Recapitulatif commande'!B21","v":0},{"$f":"IF('Recapitulatif commande'!C21=\"\",\"\",'Recapitulatif commande'!C21)","v":""},null,null,null,{"$f":"'Recapitulatif commande'!E21","v":0},{"$f":"'Recapitulatif commande'!F21","v":0},{"$f":"'Recapitulatif commande'!G21","v":""},{"$f":"IF(J35=\"\",\"\",'Recapitulatif commande'!$G$14 &\" HT\")","v":""}]
[null,5,{"$f":"'Recapitulatif commande'!B22","v":0},{"$f":"IF('Recapitulatif commande'!C22=\"\",\"\",'Recapitulatif commande'!C22)","v":""},null,null,null,{"$f":"'Recapitulatif commande'!E22","v":0},{"$f":"'Recapitulatif commande'!F22","v":0},{"$f":"'Recapitulatif commande'!G22","v":""},{"$f":"IF(J36=\"\",\"\",'Recapitulatif commande'!$G$14 &\" HT\")","v":""}]
[null,6,{"$f":"'Recapitulatif commande'!B23","v":0},{"$f":"IF('Recapitulatif commande'!C23=\"\",\"\",'Recapitulatif commande'!C23)","v":""},null,null,null,{"$f":"'Recapitulatif commande'!E23","v":0},{"$f":"'Recapitulatif commande'!F23","v":0},{"$f":"'Recapitulatif commande'!G23","v":""},{"$f":"IF(J37=\"\",\"\",'Recapitulatif commande'!$G$14 &\" HT\")","v":""}]
[null,7,{"$f":"'Recapitulatif commande'!B24","v":0},{"$f":"IF('Recapitulatif commande'!C24=\"\",\"\",'Recapitulatif commande'!C24)","v":""},null,null,null,{"$f":"'Recapitulatif commande'!E24","v":0},{"$f":"'Recapitulatif commande'!F24","v":0},{"$f":"'Recapitulatif commande'!G24","v":""},{"$f":"IF(J38=\"\",\"\",'Recapitulatif commande'!$G$14 &\" HT\")","v":""}]
[null,8,{"$f":"'Recapitulatif commande'!B25","v":0},{"$f":"IF('Recapitulatif commande'!C25=\"\",\"\",'Recapitulatif commande'!C25)","v":""},null,null,null,{"$f":"'Recapitulatif commande'!E25","v":0},{"$f":"'Recapitulatif commande'!F25","v":0},{"$f":"'Recapitulatif commande'!G25","v":""},{"$f":"IF(J39=\"\",\"\",'Recapitulatif commande'!$G$14 &\" HT\")","v":""}]
[null,9,{"$f":"'Recapitulatif commande'!B26","v":0},{"$f":"IF('Recapitulatif commande'!C26=\"\",\"\",'Recapitulatif commande'!C26)","v":""},null,null,null,{"$f":"'Recapitulatif commande'!E26","v":0},{"$f":"'Recapitulatif commande'!F26","v":0},{"$f":"'Recapitulatif commande'!G26","v":""},{"$f":"IF(J40=\"\",\"\",'Recapitulatif commande'!$G$14 &\" HT\")","v":""}]
[null,10,{"$f":"'Recapitulatif commande'!B27","v":0},{"$f":"IF('Recapitulatif commande'!C27=\"\",\"\",'Recapitulatif commande'!C27)","v":""},null,null,null,{"$f":"'Recapitulatif commande'!E27","v":0},{"$f":"'Recapitulatif commande'!F27","v":0},{"$f":"'Recapitulatif commande'!G27","v":""},{"$f":"IF(J41=\"\",\"\",'Recapitulatif commande'!$G$14 &\" HT\")","v":""}]
[null,11,{"$f":"'Recapitulatif commande'!B28","v":0},{"$f":"IF('Recapitulatif commande'!C28=\"\",\"\",'Recapitulatif commande'!C28)","v":""},null,null,null,{"$f":"'Recapitulatif commande'!E28","v":0},{"$f":"'Recapitulatif commande'!F28","v":0},{"$f":"'Recapitulatif commande'!G28","v":""},{"$f":"IF(J42=\"\",\"\",'Recapitulatif commande'!$G$14 &\" HT\")","v":""}]
[null,12,{"$f":"'Recapitulatif commande'!B29","v":0},{"$f":"IF('Recapitulatif commande'!C29=\"\",\"\",'Recapitulatif commande'!C29)","v":""},null,null,null,{"$f":"'Recapitulatif commande'!E29","v":0},{"$f":"'Recapitulatif commande'!F29","v":0},{"$f":"'Recapitulatif commande'!G29","v":""},{"$f":"IF(J43=\"\",\"\",'Recapitulatif commande'!$G$14 &\" HT\")","v":""}]
[null,13,{"$f":"'Recapitulatif commande'!B30","v":0},{"$f":"IF('Recapitulatif commande'!C30=\"\",\"\",'Recapitulatif commande'!C30)","v":""},null,null,null,{"$f":"'Recapitulatif commande'!E30","v":0},{"$f":"'Recapitulatif commande'!F30","v":0},{"$f":"'Recapitulatif commande'!G30","v":""},{"$f":"IF(J44=\"\",\"\",'Recapitulatif commande'!$G$14 &\" HT\")","v":""}]
[null,14,{"$f":"'Recapitulatif commande'!B31","v":0},{"$f":"IF('Recapitulatif commande'!C31=\"\",\"\",'Recapitulatif commande'!C31)","v":""},null,null,null,{"$f":"'Recapitulatif commande'!E31","v":0},{"$f":"'Recapitulatif commande'!F31","v":0},{"$f":"'Recapitulatif commande'!G31","v":""},{"$f":"IF(J45=\"\",\"\",'Recapitulatif commande'!$G$14 &\" HT\")","v":""}]
[null,15,{"$f":"'Recapitulatif commande'!B32","v":0},{"$f":"IF('Recapitulatif commande'!C32=\"\",\"\",'Recapitulatif commande'!C32)","v":""},null,null,null,{"$f":"'Recapitulatif commande'!E32","v":0},{"$f":"'Recapitulatif commande'!F32","v":0},{"$f":"'Recapitulatif commande'!G32","v":""},{"$f":"IF(J46=\"\",\"\",'Recapitulatif commande'!$G$14 &\" HT\")","v":""}]
[null,16,{"$f":"'Recapitulatif commande'!B33","v":0},{"$f":"IF('Recapitulatif commande'!C33=\"\",\"\",'Recapitulatif commande'!C33)","v":""},null,null,null,{"$f":"'Recapitulatif commande'!E33","v":0},{"$f":"'Recapitulatif commande'!F33","v":0},{"$f":"'Recapitulatif commande'!G33","v":""},{"$f":"IF(J47=\"\",\"\",'Recapitulatif commande'!$G$14 &\" HT\")","v":""}]
[null,17,{"$f":"'Recapitulatif commande'!B34","v":0},{"$f":"IF('Recapitulatif commande'!C34=\"\",\"\",'Recapitulatif commande'!C34)","v":""},null,null,null,{"$f":"'Recapitulatif commande'!E34","v":0},{"$f":"'Recapitulatif commande'!F34","v":0},{"$f":"'Recapitulatif commande'!G34","v":""},{"$f":"IF(J48=\"\",\"\",'Recapitulatif commande'!$G$14 &\" HT\")","v":""}]
[null,18,{"$f":"'Recapitulatif commande'!B35","v":0},{"$f":"IF('Recapitulatif commande'!C35=\"\",\"\",'Recapitulatif commande'!C35)","v":""},null,null,null,{"$f":"'Recapitulatif commande'!E35","v":0},{"$f":"'Recapitulatif commande'!F35","v":0},{"$f":"'Recapitulatif commande'!G35","v":""},{"$f":"IF(J49=\"\",\"\",'Recapitulatif commande'!$G$14 &\" HT\")","v":""}]
[null,19,{"$f":"'Recapitulatif commande'!B36","v":0},{"$f":"IF('Recapitulatif commande'!C36=\"\",\"\",'Recapitulatif commande'!C36)","v":""},null,null,null,{"$f":"'Recapitulatif commande'!E36","v":0},{"$f":"'Recapitulatif commande'!F36","v":0},{"$f":"'Recapitulatif commande'!G36","v":""},{"$f":"IF(J50=\"\",\"\",'Recapitulatif commande'!$G$14 &\" HT\")","v":""}]
[null,20,{"$f":"'Recapitulatif commande'!B37","v":0},{"$f":"IF('Recapitulatif commande'!C37=\"\",\"\",'Recapitulatif commande'!C37)","v":""},null,null,null,{"$f":"'Recapitulatif commande'!E37","v":0},{"$f":"'Recapitulatif commande'!F37","v":0},{"$f":"'Recapitulatif commande'!G37","v":""},{"$f":"IF(J51=\"\",\"\",'Recapitulatif commande'!$G$14 &\" HT\")","v":""}]
[null,null,null,null,null,null,null,null,"Total:",{"$f":"'Recapitulatif commande'!G15","v":0},{"$f":"IF(J52=\"\",\"\",'Recapitulatif commande'!$G$14 &\" HT\")","v":" HT"}]
[]
[null,null,null,"Date de livraison demandée:",{"$f":"'Recapitulatif commande'!D6:E6","v":"00:00:00"}]

{"sheet":"Recapitulatif commande","index":6,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":true,"merged":[[11,4,11,5],[27,2,27,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[1,4,1,6],[33,2,33,3],[34,2,34,3],[35,2,35,3],[36,2,36,3],[3,1,3,2],[4,1,4,2],[5,1,5,2],[28,2,28,3],[29,2,29,3],[30,2,30,3],[31,2,31,3],[32,2,32,3],[10,4,10,5],[4,4,4,5],[5,4,5,5]]}
[]
[null,null,null," RECAPITULATIF COMMANDE"]
[]
[null,"N° commande"]
[null,null,null,"Date de la commande "]
[null,null,null,"Date livraison souhaitée"]
[null,"DEMANDEUR"]
[null,"Trigramme",null,"Département","Division"]
[]
[]
[null,"CDA",null,"Compte imputation","Compte Projet"]
[]
[]
[null,"FOURNISSEUR",null,null,null,"Devise"]
[null,"N° offre/devis",null,null,null,"TOTAL commande :",{"$f":"SUM(G18:G37)","v":0}]
[]
["N°","Référence","Désignation",null,"Qté","PU","Montant"]
[1,null,null,null,null,null,{"$f":"IF(F18<>\"\",E18*F18,\"\")","v":""}]
[{"$f":"IF(C19<>\"\",A18+1,\"\")","v":""},null,null,null,null,null,{"$f":"IF(F19<>\"\",E19*F19,\"\")","v":""}]
[{"$f":"IF(C20<>\"\",A19+1,\"\")","v":""},null,null,null,null,null,""]
["",null,null,null,null,null,""]
["",null,null,null,null,null,""]
["",null,null,null,null,null,""]
["",null,null,null,null,null,""]
["",null,null,null,null,null,""]
["",null,null,null,null,null,""]
["",null,null,null,null,null,""]
["",null,null,null,null,null,""]
["",null,null,null,null,null,""]
["",null,null,null,null,null,""]
["",null,null,null,null,null,""]
["",null,null,null,null,null,""]
["",null,null,null,null,null,""]
["",null,null,null,null,null,""]
["",null,null,null,null,null,""]
["",null,null,null,null,null,""]
["",null,null,null,null,null,""]

{"sheet":"Base fournisseur","index":7,"n_rows":5,"n_cols":11,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Base Fournisseurs"]
["Nom 1","acheteur","appro","Adresse","CP","Ville","Description pays","Téléphone","Fax","Adresse de messagerie","Monnaie"]
["Fournisseur 1",null,null,"1 chemin du fournisseur",78459,"ABC","FRANCE",145784587,45788956,"INFO@FRS1.COM","EUR"]
["Fournisseur 2",null,null,"2 chemin du fournisseur",45869,"JGHD","Belgique",45784512,45788956,"INFO@FRS2.CMO","EUR"]
["Fournisseur 3",null,null,"3 chemin du fournisseur",12456,"FESFS","FRANCE",45123569,2356485962,"INFO@FRS3.COM","EUR"]

{"sheet":"Base entreprise","index":8,"n_rows":4,"n_cols":11,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Base entreprise"]
["Trigramme","Prenom","Nom","Adresse","CP","Ville","Pays","Mail","Tel","Fax","Département"]
["ABE","Anne","B","Champ 8",7845,"esdf","France","qwe@we.com",41229895791,0,"Service 1"]
["ABG","Alexandre","C","Chemin de la X 31",4578,"fds","Belgique","ewrw@ko.com"," 41 1245784 26 65",0,"Service 2"]