{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Course10","Sheet1","Sheet2","Sheet3","xl_DCF_History","Classified as UnClassified"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":1,"defined_names":8,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Course10","index":0,"n_rows":70,"n_cols":8,"rows_kept":70,"merged":[[0,0,0,2],[0,3,0,5],[0,7,0,8],[2,0,2,5],[5,2,5,5],[6,2,6,5],[7,2,7,5],[9,2,9,3],[12,1,12,4],[57,1,57,4],[59,2,59,3],[60,2,60,3],[61,2,61,3],[62,2,62,3],[63,2,63,3],[65,1,65,4]]}
["MODULE 10",null,null,"Interfacing with powerpaint",null,null,"Difficulty",4]
[]
["How to send excel data's to Powerpaint"]
[]
[]
[null,"Objectifs","1. Managing the powerpaint application via VBA"]
[null,null,"2. Existing / New presentation"]
[null,null,"3. Managing the elements to send"]
[]
[null,"Pre-requisites","Previous courses"]
[]
[]
[9.1,"Test case - example: let's create some data's to be sent"]
[]
[null,"Description","Here are some excel elements we would like to send to powerpaint"]
[]
[null,"PPT_Rng1","BU code","Pline code","CP","CP Mat","Lst6M bill qty","FG WIP Qty"]
[null,"(data's range)","N8","AB3100","AF-AB3100-DI-SAG","1900-01-15",96000,""]
[null,null,"N8","AB3100","AF-AB3100-DI-SAM","1900-01-15",18000,""]
[null,null,"N8","AB3100","AF-AB3100-DI-SHP","1900-01-15",627000,""]
[null,null,"N8","TC2811","AB8500-MB14O04","1900-01-30",800,""]
[null,null,"N8","TC2811","AB8500-MB1TO04","1900-01-30",8750,""]
[null,null,"N8","TC2811","AB8500-MB1TSA4","1900-01-30",5724250,58835]
[null,null,"N8","TC3611","PM2101AST","1900-01-29",1006,""]
[null,null,"N8","TC3611","PM2301AST","1900-01-29",80332,""]
[null,null,"N8","TC6011","AB8505-CB1TH/3","1900-01-15",12500,""]
[null,null,"N8","TC6011","AB8505-DB1TH43","1900-01-21",149800,31888]
[null,null,"N8","TC6011","AB8505-DB1TH53","1900-01-29",5282500,223358]
[null,null,"N8","TC6011","AB8505-DB1TH53","1900-01-29",5912200,43073]
[]
[null,"Some graphs too"]
{"$rows_empty":15}
[null,"And a pivot table","Row Labels","CP Mat","Sum of Lst6M bill qty","Sum of FG WIP Qty"]
[null,null,"AB3100",15,741000,0]
[null,null,"TC2811",30,5733800,58835]
[null,null,"TC3611",29,81338,0]
[null,null,"TC6011",15,12500,0]
[{"$nulls":3},21,149800,31888]
[{"$nulls":3},29,11194700,266431]
[null,null,"Grand Total",null,17913138,357154]
[]
[]
[]
[9.2,"Let's create the environment: what to export and how"]
[{"$nulls":5},"Name contening"]
[null,"PPT_EXPORT","Include data's range",null,true,"PPT_Rng"]
[null,null,"Include pivot tables",null,true]
[null,null,"Include graphs",null,true]
[null,null,"Insert as hyperlink",null,false]
[null,null,"Copy as picture",null,true]
[]
[9.3,"Set the powerpoint object libray"]
[]
[null,"Description"]
[null,"To allow VBA to dialog and drive powerppoint, the reference to the Object libray must be active"]
[null,"If not, your have to activate it thru Tools menu => References"]

{"sheet":"Sheet1","index":1,"n_rows":3,"n_cols":5,"rows_kept":3}
["NOM","PRENOM","CATEG","TITRES","DERNIER"]
["PROST","ALAIN","F1",4,1993]
["LOEB","SEBASTIEN","WRC",9,2013]

{"sheet":"Sheet2","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Sheet3","index":3,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"xl_DCF_History","index":4,"n_rows":2,"n_cols":7,"rows_kept":2,"hidden":true}
["CLINAME","DATETIME","DONEBY","IPADDRESS","APPVER","RANDOM","CHECKSUM"]
["ቤችቒቻተኂኂቸትቸቴታ","ቆሾቁቂሾቁሿቀቄሯሯቀቅ቉ቄቈ቟ቜሯሷቖቜባሺቁ቉ሿሸ","ቢባቫቑኁቴቼቾችታኅ","ቖቝቑቃሿቃቅቁቂ","ቃሽሿሽቁሽሿ",15,"ቃቂሿቅ"]

{"sheet":"Classified as UnClassified","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}