{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["More -->","SelectFile"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"More -->","index":0,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,"Free Tutorials"]
[]
[null,null,"Browse through my free Excel tutorials to discover dashboard tips, chart tricks and advanced formula  techniques. "]
[]
[]
[null,null,"Courses to help you succeed"]
[]
[null,null,"If you'd like to learn Excel in a structured way and in your own time, check out my bestselling courses:"]
[]
[]
[null,null,"Favorite Resources"]
[]
[null,null,"Check out my list of favorite resources. It includes links to Excel books I've found helpful, courses on topics I'm interested in such as Power Query, data science and more."]
[]
[]
[]
[]
[]
[null,null,"Sharing & Learning"]
[null,null,"Feel free to share this with anyone who can benefit!"]

{"sheet":"SelectFile","index":1,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["User Selects a File - GetOpenFileName Method"]
[]
["Note: In the sales reporting tool, you will learn how to use MultiSelect to import data from many files at once."]
[]
["1. Allow the user to select an Excel file"]
["2. Copy range A1:E20 of sheet 1 from the file selected and paste it starting from A10 below."]
[]
[]
[]
["Company ID","Sales Document","Document Date","Customer code","Article code"]
["AT1030",84030,43380,8050,120]
["AT1030",84030,43380,8050,104]
["AT1030",84030,43380,8050,105]
["AT1030",84030,43380,8050,107]
["AT1030",84031,43381,8040,104]
["AT1030",84031,43381,8040,107]
["AT1030",84031,43381,8040,110]
["AT1030",88112,43384,8040,110]
["AT1030",88112,43384,8040,119]
["AT1030",88112,43384,8040,120]
["AT1030",88112,43384,8040,116]
["AT1030",88112,43384,8040,111]
["1030SE6",88112,43384,8040,110]
["1030SE6",88112,43384,8040,109]
["1030SE6",85442,43388,8050,107]
["1030SE6",85442,43388,8050,103]
["1030SE6",85442,43388,8050,104]