{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Úvod","Proměnné","Operatory","Přiřazování","Porovnávání","Přiřazení vs Porovnání","Poznámky ve VBA","Like","Deklarace","Úkol"],"not_rendered":{"charts":0,"images":12,"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":"Úvod","index":0,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[28,1,28,11],[1,2,1,9],[13,2,14,6],[16,3,17,6],[17,7,17,9]]}
[]
[null,null,"Jak na Excel  - VBA"]
[]
[]
[null,null,null,"Obsah cvičení"]
[null,null,null,null,"Proměnné základ"]
[null,null,null,null,"Operátory"]
[null,null,null,null,"Porovnání a přiřazení "]
[null,null,null,null,"Like"]
[null,null,null,null,"Psaní poznámek do kódu"]
[]
[]
[]
[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,null,null,null,"https://office.lasakovi.com/excel/vba-teorie-zaklady/operatory-excel-vba/"]
[null,null,null,null,"https://office.lasakovi.com/excel/vba-teorie-zaklady/promene-excel-vba/"]
[null,null,null,null,"https://office.lasakovi.com/excel/vba-teorie-zaklady/Operator-Like-Excel-VBA/"]
[]
[]
[null,"Copyright, Pavel Lasák 2017  rev 2019"]

{"sheet":"Proměnné","index":1,"n_rows":49,"n_cols":3,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3]]}
["Proměnné"]
["office.lasakovi.com"]
[]
[null,"Složka","02_VBA_Uvod"]
[null,"Sešit","02d- VBA uvod - Promenne .xlsm"]
[null,"List","Proměnné"]
[]
[null,"Úkol"]
[null,"Jak vhodně pojmenovat proměné (identifikátory)"]
[]
[null,"Co je proměnná"]
[null,"Identifikator, který nabývá známých a nebo neznámých hodnot"]
[null,"Může jit o slovo, číslo, rozsah buněk, název sešitu, list…."]
[]
[null,"Tipy"]
[null,"Vhodně pojmenovat"]
[null," * DatumNastupuDoZamestani vs xy"]
[]
[]
[null,"Přiřazení hodnoty do proměnné"]
[]
[null,"HodnotaVek = 10"]
[null,"TextVek = \"10\""]
[null,"Pozdrav = \"ahoj\""]
[]
[null,"' Pozor číslo vs text"]
[null,"' viz Int"]
[null,"' Zobrazení viz MsgBox nebo Debug.Print"]
[null,"' Spojování viz slučováci operatory & +"]
[]
[]
[]
[null,"Definice (deklarace)  proměnné viz později"]
[null,"Jak na názvy? Viz sešit deklarace"]
[null,"Dim HodnotaVek As Integer"]
[null,"' Viz samostatný sešit"]
[]
[]
[]
[null,"Pole jako proměná víz dále"]
[null,"Dim oddeleni As Variant"]
[null,"oddeleni = Array(\"IT\", \"GR\", \"LOG\")"]
[null,"MsgBox oddeleni(1)"]
[]
[]
[null,"Nefunguje!"]
[null,"a = b = c = 2"]
[null,"MsgBox (a)"]
[null,"' pro proměnnou a vypíše False ne 2 jako třeba Phyton"]

{"sheet":"Operatory","index":2,"n_rows":80,"n_cols":5,"rows_kept":80,"cut":false,"hidden":false,"merged":[[79,0,79,3],[0,0,0,3],[1,0,1,3]]}
["Operátory"]
["office.lasakovi.com"]
[]
[null,"Složka","02_VBA_Uvod"]
[null,"Sešit","02d- VBA uvod - Promenne .xlsm"]
[null,"List","Operatory"]
[]
[null,"Pří práci ve VBA se hodí vědět"]
[null,"Viz v dalších sešitech"]
[]
[null,"Aritmetické, atematické operátory"]
[null,"pro provádění matematických výpočtů",null,null,"Další podkladové materiály"]
[null,null,null,null,"https://office.lasakovi.com/excel/vba-teorie-zaklady/Operator-Like-Excel-VBA/"]
[null,"^","x = 2  ^ 2  ' Dvě na druhou"]
[null,"*"]
[null,"/"]
[null,"+"]
[null,"-"]
[null,"%"]
[null,"\\"]
[null,"Mod"]
[]
[null,"Využití ve výpočtech"]
[]
[null,"Logické operátory"]
[null,"Logické (bitové) operátory - pro provádění logických operací"]
[]
[null,"And","nebo nahrazení *"]
[null,"Or","nebo nahrazení +"]
[null,"Not"]
[null,"Xor"]
[]
[null,"Více napříkald v podmínkách"]
[]
[]
[null,"Porovnávací operátory"]
[null,"Operátory pro srovnávání/porovnávání"]
[null,"Is"]
[null,"Like"]
[null,"<"]
[null,">"]
[null,">="]
[null,"<="]
[null,"<>"]
[null,"="]
[]
[]
[null,"Přiřazení operátor"]
[null,"Operátor přiřazení slouží pro přiřazení hodnot, proměnných."]
[null,"=","je stejný jako operátor porovnání!",null,"Hodnota = 1"]
[null," :=",null,null,"ActiveWorkbook.SaveAs Filename:=\"D:\\test.xlsm\", Password:= \"AAA\""]
[]
[]
[null,"Slučovací (spojovací) operátory"]
[null,"Slučovací (spojovací) operátory - pro spojování řetězců, znaků, hodnot"]
[null,"&","slučování"]
[null,"+","sčítání / slučování "]
[null,"Pozor text a číslo"]
[]
[]
[]
[]
[]
[null,"Ostatní operátory (znaky)"]
[null,"_ ","pro rozdělení řádku s kódem"]
[null,",","oddělovač argumentů"]
[null,". ","Desetiná místa (desetinná tečka)"]
[null,":","rozsah až","A1:B5"]
[null,"\"\"","statická hodnota, co bude zobrazeno"]
[null,"'","apostrof pro poznámky"]
[null,"vbCrLf","nový řádek"]
[null,"~"," tilda (vlnovka) pro hledání speciálních znaků"]
[]
[]
[]
[null,"Viz nastavit si VBA pro poznámky, další list"]
[]
[]
[]
["Pavel Lasák"]

{"sheet":"Přiřazování","index":3,"n_rows":39,"n_cols":3,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3]]}
["Přiřazování do proměnné"]
["office.lasakovi.com"]
[]
[]
[null,"Složka","02_VBA_Uvod"]
[null,"Sešit","02d- VBA uvod - Promenne .xlsm"]
[null,"List","Přiřazování"]
[]
[null,"Přiřazení"]
[]
[null,"x= 10"]
[null,"' do proměnné X se přiřadí 10"]
[null,"' viiz číslo vs text"]
[]
[null,"x = 1 + 1"]
[null,"' viz dále zobrazit v MsgBoxu nebo Debug printu"]
[null,"' do x se přiřadí součet čísel 1 + 1"]
[]
[null,"y = 2 -1"]
[null,"' do y se přiřadí rozdíl čísel 2 - 1"]
[]
[null,"x = 1 & 2"]
[null,"' do proměné x se přiřadí sloučení 1 a 2 tedy 12"]
[]
[null,"x = 1 = 2"]
[null,"' do proměnné se přiřadí logická hodnota True nebo False"]
[null,"' Zde False protože se 1 nerovná 2"]
[null,"y = 1 = 1"]
[null,"'Vratí True 1 = 1"]
[]
[]
[]
[]
[null,"Dim x As Integer"]
[null,"x = 1 + 1"]
[null,"' P0řiřazení za vaužití deklarace, deklarace viz samostatný sešit"]
[]
[null,"Dim x As Boolean"]
[null,"x = 1 < 2"]

{"sheet":"Porovnávání","index":4,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3]]}
["Porovnávání"]
["office.lasakovi.com"]
[]
[]
[null,"' Využijeme v podmínkách atd"]
[]
[null,"Porovnání"]
[null,"If (a=1) And (b=1) then"]
[null," '' něco"]
[null,"End If"]
[]
[null,"If (a=1) Or (b=1) then"]
[null," '' něco"]
[null,"End If"]
[]
[null,"' Porovnání a přiřazení"]
[null,"a = b = 1"]
[null,null,"b = 1","… Porovnání"]
[null,null,"a = (přiřadí se výcledek porovnání b a 1)"]
[]
[]
[]
[]
[null,"Viz samostatná kapitola Podmínky"]

{"sheet":"Přiřazení vs Porovnání","index":5,"n_rows":39,"n_cols":3,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3]]}
["Proměnné"]
["office.lasakovi.com"]
[]
[null,"Složka","02_VBA_Uvod"]
[null,"Sešit","02d- VBA uvod - Promenne .xlsm"]
[null,"List","Přiřazení vs Porovnání"]
[]
[]
[null,"Přiřazení hodnoty do proměnné vs porovnání"]
[]
[]
[null,"PocetLet  = HodnotaVek = 10"]
[null,"MsgBox (PocetLet)"]
[null,"' Proto výsledek Flase"]
[]
[]
[null,"Rem   Do PocetLet se přiřadí porovnání HodnotaVek = 10"]
[null,"HodnotaVek = 10"]
[null,"PocetLet  = HodnotaVek = 10"]
[null,"MsgBox (PocetLet)"]
[null," Proto výsledek True"]
[]
[]
[]
[null,"a = 0 > 1"]
[null,"MsgBox (a)"]
[]
[null,"a = 0 < 2"]
[null,"MsgBox (a)"]
[]
[null,"a = 0 < \"3\""]
[null,"MsgBox (a)"]
[]
[null,"a = 0 < \"4,1\""]
[null,"MsgBox (a)"]
[]
[null,"'' chyba"]
[null,"a = 0 < \"4.1\""]
[null,"MsgBox (a)"]

{"sheet":"Poznámky ve VBA","index":6,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2]]}
["Poznámky tipy triky"]
["office.lasakovi.com"]
[]
["Složka","02_VBA_Uvod"]
["Sešit","02d- VBA uvod - Promenne .xlsm"]
["List","Poznámky ve VBA"]
[null,null,null,null,"View  >>  Toolbars  >> Customize"]
[null,"Doporučení psát si poznámky v kódu"]
[null,"využít apostrof '"]
[]
[null,"Tip: Upravit si VBA o ikonky zapoznámkovat a odpoznámkovat"]
[null,"viz: Popis VBA v samostatném sešitě"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Prostor pro vaše poznámky"]

{"sheet":"Like","index":7,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2]]}
["Like"]
["office.lasakovi.com"]
[]
[]
[null,"Option Compare Binary "]
[]
[null,"příklad řazení znaků:"]
[null,"0 < 9 < A < B < C < D < Z < a < z < Á < á < Ě < ě < Ř "]
[]
[]
[null,"Option Compare Text"]
[]
[null,"příklad řazení znaků:"]
[null,"0 < 9 < (A=a) < (Á = á) < (B=b) < (E=e) < (Ě=ě) < (Z=z)"]
[]
[]
[]
[null,"Testy",null,"Test","Binary","Text"]
[null,null,null,"Debug.Print \"123-345\" Like \"###[-]###\"","True","True"]
[null,"If \"Ě\" < \"Ř\" Then",null,"Debug.Print \"123-345\" Like \"###[-.]###\"","True","True"]
[null,"    MsgBox (\"Ano\")",null,"Debug.Print \"abcpesabc\" Like \"*pes*\"","True","True"]
[null,"Else",null,"Debug.Print \"abcpesabc\" Like \"*PES*\"","False","True"]
[null,"    MsgBox (\"Ne\")",null,"Debug.Print \"abcpesabc\" Like \"pes*\"","False","False"]
[null,"End If",null,"Debug.Print \"pas\" Like \"p?s\"","True","True"]
[null,null,null,"Debug.Print \"pas\" Like \"p??s\"","False","False"]
[null,null,null,"Debug.Print \"pas\" Like \"P?S\"","False","True"]
[null,null,null,"Debug.Print \"pas\" Like \"P??S\"","False","False"]
[null,null,null,"Debug.Print \"A4C\" Like \"A#C\"","True","True"]
[null,null,null,"Debug.Print \"ABC\" Like \"A??C\"","False","False"]
[null,null,null,"Debug.Print \"A123C\" Like \"A*C\"","True","True"]
[null,"Debug.Print \"JakNaExcel\" Like \"*Excel*\" ",null,"Debug.Print \"1B3\" Like \"1[A-Z]3\"","True","True"]
[null,"Debug.Print \"JakNaExcel\" Like \"*Google*\"",null,"Debug.Print \"123\" Like \"1[!A-Z]3\"","True","True"]
[null,null,null,"Debug.Print \"1B3\" Like \"1[!A-Z]3\"","False","False"]
[null,null,null,"Debug.Print \"a\" Like \"[a,c,k]\"","True","True"]
[null,null,null,"Debug.Print \"b\" Like \"[a,c,k]\"","False","False"]
[null,null,null,"Debug.Print \"b\" Like \"[!a,c,k]\"","True","True"]
[null,null,null,"Debug.Print \"bb\" Like \"*b*\"","True","True"]
[null,null,null,"Debug.Print \"bb\" Like \"*!b*\"","False","False"]

{"sheet":"Deklarace","index":8,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2]]}
["Deklarace"]
["office.lasakovi.com"]
[]
[null,"Viz samostatná kapitola později"]
[null,"Případně prostor pro vaše poznámky"]
[]
[null,"Dim HodnotaVek As Integer"]

{"sheet":"Úkol","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}