{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["ACCUEIL","Feuil1","HISTORIQUE","DATAS"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":17,"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":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Feuil1","index":1,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,"ormulaire sous VBA"]
[]
[null,null,"Steph57590 - 24 nov. 2014 à 10:07"]
[null,null,"Suivre"]
[null,null,"Bonjour."]
[]
[null,null,"Je me suis inspiré du fichier de Ninconz, pour créer le mien, étant novice sur VBA voilà les problèmes que je rencontre :"]
[]
[null,null,"- Quand je valide la saisie de mon userform, il transpose les informations sur ma"]
[null,null,"page d'accueil et non sur la feuille prévue à cet effet."]
[null,null,"- Le numéro de commande ne s'agrémente qu'une ligne sur deux et est il"]
[null,null,"possible de le faire apparaitre sur le formulaire de saisie ?"]
[null,null,"- Le montant engagé et facturé, ne sont pas sur mon tableau (HISTORIQUE)"]
[null,null,"repris comme des chiffres, ce qui ne me permet pas de les retravailler sous"]
[null,null,"Excel."]
[null,null,"- J'aimerai pouvoir rappeler les enregistrement précédent à l'écran, afin de les"]
[null,null,"mettre à jour, comment coder mon textbox ?"]
[]
[null,null,"Voici une partie de mon fichier, car j'ai peur que le le fichier complet soit un peu gros, si quelqu'un pouvez y jeter un oeil et me venir en aide, cela me rendrai un grand service. https://mon-partage.fr/f/oQyBCDcI/"]
[]
[null,null,"Bien cordialement."]

{"sheet":"HISTORIQUE","index":2,"n_rows":6,"n_cols":15,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["NUMERO DE COMMANDE","Fournisseur","Orgisme payeur","PCG Réduit","Activité","Type de soins","Observations","Montant engagé","Montant facturé","N° de facture","Patient","Armée","CMA","Date d'envoie","Cloturée"]
["DRSSA- 14- 0001","1000735089 - Cercle Interarmées de la BdD de Metz","REGIE","6118200000","Alimention","","CMA METZ","1256,10","1256,10","2014005656","","","","21 novembre 2014","NON"]
["","NC0000325 - Centre de biologie médicale CBM 25","DAPSA","6135000000","Fontionnement des hopitaux","Biologie","","85,72","85,72","567444","POTIN Olivier","MARINE","CHARLEVILLE MEZIERES","21 novembre 2014","NON"]
["DRSSA- 14- 0002","NC9900001 - DUPRES Jacky","REGIE","6135000000","Fontionnement des hopitaux","Médecin","REMBOURSEMENT A L'INTERESSE","33,00","33,00","SANS","","","BELFORT","21 novembre 2014","NON"]
["","NC0000325 - Centre de biologie médicale CBM 25","REGIE","6135000000","Fontionnement des hopitaux","Biologie","AV SUIPPES","87,12","87,12","85411","MARLY Yves","GENDARMERIE","EPINAL - LUXEUIL","21 novembre 2014","NON"]
["DRSSA- 14- 0003","NC9900001 - DUPRES Jacky","GSBDD","6188000000","Marché DAPSA (hors BF)","C.M.O.","",123.41000366210937,123.44999694824219,"azerty","aer qsd","MARINE","STRASBOURG - HAGUENAU","12 décembre 2022","OUI"]

{"sheet":"DATAS","index":3,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["DEPARTEMENT",null,"Fournisseur",null,"DIVISION",null,"CDA",null,"IMPUT",null,"COMPTE PROJET",null,"DEVISE"]
["REGIE",null,"1000014130 - Laboratoire INOVALYS",null,"Alimention",null,"Imagerie",null,6118200000,null,"AIR",null,"AUTRES UNITES"]
["DAPSA",null,"1000735089 - Cercle Interarmées de la BdD de Metz",null,"Déplacement des personnels",null,"Biologie",null,6153110000,null,"MARINE",null,"BELFORT"]
["GSBDD",null,"NC0000325 - Centre de biologie médicale CBM 25",null,"Communications et relations publiques",null,"Médecin",null,6063200000,null,"AUTRES",null,"22 novembre 2014"]
[null,null,"NC9900001 - DUPRES Jacky",null,"Fontionnement des hopitaux",null,"Dentiste",null,6063300000,null,"SANTE",null,"CHARLEVILLE MEZIERES"]
[null,null,null,null,"Communications et relations publiques",null,"Kinésithérapie",null,6135000000,null,"GENDARMERIE",null,"COLMAR"]
[null,null,null,null,"Formation et instruction",null,"Hospitalisation",null,6182000000,null,"AUTRES",null,"DIJON"]
[null,null,null,null,"Marché DAPSA (hors BF)",null,"Transport",null,6183000000,null,null,null,"EPINAL - LUXEUIL"]
[null,null,null,null,"Dépense A.C.S.G.",null,"C.M.O.",null,6188000000,null,null,null,"METZ"]
[null,null,null,null,null,null,"E.F.R.",null,6115470000,null,null,null,"MOURMELON MAILLY"]
[null,null,null,null,null,null,null,null,6118600000,null,null,null,"NANCY"]
[null,null,null,null,null,null,null,null,"6156-drssa",null,null,null,"PHALSBOURG"]
[null,null,null,null,null,null,null,null,"6156-cma",null,null,null,"SAINT DIZIER - CHAUMONT"]
[null,null,null,null,null,null,null,null,6118100000,null,null,null,"STRASBOURG - HAGUENAU"]
[null,null,null,null,null,null,null,null,6118480000,null,null,null,"VERDUN"]
[null,null,null,null,null,null,null,null,"G611810"]
[null,null,null,null,null,null,null,null,"G606550"]
[null,null,null,null,null,null,null,null,"G606663"]
[null,null,null,null,null,null,null,null,"G606830"]
[null,null,null,null,null,null,null,null,"G606840"]
[null,null,null,null,null,null,null,null,"G621281"]
[null,null,null,null,null,null,null,null,"G606650"]
[null,null,null,null,null,null,null,null,"G606661"]
[null,null,null,null,null,null,null,null,"G606662"]
[null,null,null,null,null,null,null,null,"G606720"]