{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["stock","Accueil","Produit","REF","Feuil2","initiales","Feuil3","Feuil5","CdC"],"not_rendered":{"charts":0,"images":17,"macros":1,"external_links":0,"defined_names":10,"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":"stock","index":0,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["EMPL.","Référence","Produit","Code","Date","Quantité"]
["A.1.3",4,"lame",55,"2016-06-02","1p"]
["A.2.0",5,"scie",99,"2016-06-03","1p"]
["A.2.1",6,"clés 8",97,"2016-06-04","1p"]
["A.2.2",7,"clés 9",96,"2016-06-05","1p"]
["A.2.3"]
["A.3.0"]
["A.3.1"]
["A.3.2",4,"lame",55,"2016-06-09","1p"]
["A.3.3"]
["A.4.0"]
["A.4.1",null,null,null,null,null,null," "]
["A.4.2",2,"marteau",11,"2016-06-13","1p"]

{"sheet":"Accueil","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Produit","index":2,"n_rows":9,"n_cols":1,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["tournevis"]
["marteau"]
["clés 5"]
["clés 6"]
["clés 7"]
["clés 8"]
["clés 9"]
["boite vis"]
["pointe"]

{"sheet":"REF","index":3,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]

{"sheet":"Feuil2","index":4,"n_rows":2,"n_cols":6,"rows_kept":2,"cut":false,"hidden":true,"merged":[[0,0,0,3]]}
[]
["Emplacement","Référence","Désignation","Code",null,"Quantité"]

{"sheet":"initiales","index":5,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["BL "]
["BG"]
["DB"]
["CN"]

{"sheet":"Feuil3","index":6,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["titi"]
["toto"]
["tata"]
["tutu"]

{"sheet":"Feuil5","index":7,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["SUIVI"]
["date","heure","initiales","action","Produit","camion"]
["28/06/2016","19:30:44","BG","SORTIE","6","toto"]
["29/06/2016","15:50:22","BG","SORTIE","4","tata"]
["29/06/2016","15:54:36","DB","ENTREE","boite vis"]
["29/06/2016","17:35:49","BG","SORTIE","3","toto"]
["29/06/2016","17:41:51","BG","SORTIE","3","toto"]
["29/06/2016","17:54:37","BG","SORTIE","4","tata"]
["02/07/2016","13:41:04","BL ","SORTIE","1","toto"]
["02/07/2016","13:43:12","BG","SORTIE","1","titi"]
["02/07/2016","13:49:29","CN","SORTIE","6","tutu"]
["02/07/2016","13:49:55","BG","SORTIE","2","toto"]
["02/07/2016","13:51:29","BL ","SORTIE","1","toto"]
["02/07/2016","13:53:15","BL ","SORTIE","1","tutu"]
["02/07/2016","13:53:38","BL ","SORTIE","1","titi"]
["02/07/2016","13:54:06","BG","SORTIE","2","toto"]
["02/07/2016","13:55:05","BL ","SORTIE","6","toto"]
["02/07/2016","13:57:05","BL ","SORTIE","1","toto"]
["02/07/2016","14:02:30","BL ","SORTIE","1","titi"]
["02/07/2016","14:05:11","BL ","SORTIE","1","titi"]
["02/07/2016","14:06:31","BL ","SORTIE","1","titi"]
["02/07/2016","14:06:54","BL ","SORTIE","1","titi"]
["02/07/2016","14:08:49","BL ","SORTIE","1","titi"]
["02/07/2016","14:10:43","BL ","SORTIE","1","titi"]
["02/07/2016","14:11:56","BL ","SORTIE","1","toto"]
["02/07/2016","14:13:32","BG","SORTIE","1","titi"]
["02/07/2016","14:16:51","BL ","SORTIE","1","toto"]
["02/07/2016","14:17:41","BL ","SORTIE","1","titi"]
["02/07/2016","14:19:07","BL ","SORTIE","2","toto"]
["02/07/2016","14:23:37","BL ","SORTIE","1","titi"]
["02/07/2016","14:25:38","BL ","SORTIE","1","titi"]
["02/07/2016","14:26:27","CN","SORTIE","4","toto"]

{"sheet":"CdC","index":8,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Quitter feuille ??"]
[]
[null,null,"Tourdumond - 2 juil. 2016 à 13:39"]
[null,null,"Suivre"]
[null,null,"Bonjour le forum"]
[]
[null,null,"je suis face à mur que je n'arrive pas à résoudre, 1 problème qui sera facile pour les AS de la VBA"]
[null,null,"Vous trouverez mon fichier en lien ci-dessous"]
[null,null,"La procédure:"]
[null,null,"-Ecran Accueil, on clique sur recherche, ça ouvre formulaire d'identification, valide"]
[null,null,"-Une inputbox demande la référence, OK"]
[null,null,"-Ouvre le formulaire recherche, on reprend la réf. dans la combo, ce qui affiche dans la listbox, double clique sur le produit désiré."]
[null,null,"-Ouvre le formulaire affichage, qui indique les infos sur le produit,on clique sur éffacer"]
[null,null,"-Ouvre le dernier formulaire sortie, on reprend l'emplacement du formulaire affichage, une fenêtre de confirmation s'affiche, Ok, les 5 dernières cases s'éffacent."]
[]
[null,null,"Mon est que lorsqu'on arrive à la fin de la procédure, que la fenêtre de confirmation s'ouvre et qu'on valide OK, j'aurai voulu un retour sur l'onglet Accueil."]
[null,null,"le lien du fichier: http://www.cjoint.com/c/FFDqfehTnx3"]
[]
[null,null,"Je précise que j'ai essayé sheets(\"Accueil\").select ou activate et ça ne fonctionne pas."]
[]
[null,null,"Je tiens à remercier tous le monde, de l'aide et du temps que vous allez me consacré"]
[null,null,"Cordialement."]
[null,null,"Ps Le mot de passe pour ouvrir VBA est A1A1A1"]