{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Úvod","Datum - filtry","Poznámky"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":1,"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":"Úvod","index":0,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,2,1,9],[10,2,11,6],[13,3,14,6],[14,7,14,9],[25,1,25,11]]}
[]
[null,null,"Jak na Excel  - VBA"]
[]
[]
[null,null,null,"Obsah cvičení"]
[null,null,null,null,"Datum a čas ve filtru"]
[]
[]
[]
[]
[null,null,"Pavel Lasák"]
[]
[]
[null,null,null,"Lektor, expert na Microsoft Excel, držitel prestižního ocenění Microsoftu MVP v České republice"]
[null,null,null,null,null,null,null,5002722]
[]
[]
[]
[]
[null,null,null,"Další informace ke cvičení:"]
[]
[]
[]
[]
[]
[null,"Copyright, Pavel Lasák 2017"]

{"sheet":"Datum - filtry","index":1,"n_rows":82,"n_cols":8,"rows_kept":82,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,4]]}
["Datum filtry VBA Excel",null,null,null,null,"Využít pro filtrovnání Dateserial"]
["http://office.lasakovi.com/"]
[]
[null,"Datum","Id"]
[null,"2014-06-29",1]
[null,"2014-06-30",2]
[null,"2014-07-01",3]
[null,"2014-07-02",4]
[null,"2014-07-03",5]
[null,"2014-07-04",6]
[null,"2014-07-05",7]
[null,"2014-07-06",8]
[null,"2014-07-07",9]
[null,"2014-07-08",10]
[null,"2014-07-09",11]
[null,"2014-07-10",12]
[null,"2014-07-11",13]
[null,"2014-07-12",14]
[null,"2014-07-13",15]
[null,"2014-07-14",16]
[null,"2014-07-15",17]
[null,"2014-07-16",18]
[null,"2014-07-17",19]
[null,"2014-07-18",20]
[]
[null,null,null,null,null,"Zrušit filtr c daném sloupci - pro další testy"]
[null,null,null,null,null,null,null,"Opakování"]
[null,null,null,null,null,"Range(\"$B$4\").AutoFilter Field:=1",null,"Oblasti dynamicky"]
[]
[]
[null,null,null,null,null,"Ukázka Filtruj > 7.7.2014"]
[]
[null,null,null,null,null,"' Deklarace je důležitá viz samostatná kapitola",null,"Dim Date1 As Date"]
[null,null,null,null,null,"Dim Date1 As Date",null,"Dim Date_str As Long"]
[null,null,null,null,null,"Dim Date_str As Long"]
[null,null,null,null,null,null,null,"Date1 = DateSerial(2014, 7, 7)"]
[null,null,null,null,null,"Date1 = DateSerial(2014, 7, 7)",null,"Date_str = Date1"]
[null,null,null,null,null,"Date_str = Date1"]
[null,null,null,null,null,null,null,"MsgBOx(Date1)"]
[null,null,null,null,null,"Range(\"B4\").AutoFilter Field:=1, Criteria1:=\">\" & Date_str",null,"MsgBOx(Date_str)"]
[null,null,null,null,null," ' jinak doplnit o kontorlu"]
[]
[]
[]
[null,null,null,null,null,"Rozsah"]
[]
[null,null,null,null,null,"Dim Date1 As Date"]
[null,null,null,null,null,"Dim Date2 As Date"]
[null,null,null,null,null,"Dim Date_str1 As Long"]
[null,null,null,null,null,"Dim Date_str2 As Long"]
[]
[null,null,null,null,null,"Date1 = DateSerial(2014, 7, 7)"]
[null,null,null,null,null,"Date_str1 = Date1"]
[]
[null,null,null,null,null,"Date2 = DateSerial(2014, 7, 16)"]
[null,null,null,null,null,"Date_str2 = Date2"]
[]
[null,null,null,null,null,"Range(\"B4\").AutoFilter Field:=1, Criteria1:=\">\" & Date_str1, _"]
[null,null,null,null,null," Operator:=xlAnd, Criteria2:=\"<\" & Date_str2"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Zadávat datum"]
[]
[null,null,null,null,null,"Dim Datum As Date"]
[null,null,null,null,null,"Dim Date_str As Long"]
[null,null,null,null,null,"Dim Zprava As String"]
[null,null,null,null,null,"Dim Titulek_dialogu As String"]
[null,null,null,null,null,"Dim Vychozi_hodnota As String"]
[]
[]
[null,null,null,null,null,"Zprava = \"Zadej datum\""]
[null,null,null,null,null,"Titulek_dialogu = \"Vstupní dialog pro filtr\""]
[null,null,null,null,null,"Vychozi_hodnota = \"16.7.2014\""]
[]
[null,null,null,null,null,"Datum = InputBox(Zprava, Titulek_dialogu, Vychozi_hodnota, 100, 200)"]
[null,null,null,null,null,"Date_str = Datum"]
[]
[null,null,null,null,null,"Range(\"B4\").AutoFilter Field:=1, Criteria1:=\">\" & Date_str"]

{"sheet":"Poznámky","index":2,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5]]}
["Datum filtry VBA Excel"]
["http://office.lasakovi.com/"]
[]
[]
[null,"Prostor pro poznámky"]