{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Environment Variables"],"not_rendered":{"charts":0,"images":0,"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":"Environment Variables","index":0,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":false,"merged":[[7,5,7,9],[8,5,8,9],[9,5,9,9],[0,0,0,3],[3,5,3,9],[4,5,4,9],[5,5,5,9],[6,5,6,9]]}
["Using Windows Environment Variables In VBA"]
[]
[null,"Variable Name","Function Result"]
[null,"ALLUSERSPROFILE",{"$f":"EnvironmentResult(B4)","v":"C:\\ProgramData"},null,null,"Using Windows Environment Variables In VBA"]
[null,"APPDATA",{"$f":"EnvironmentResult(B5)","v":"C:\\Users\\Christos\\AppData\\Roaming"},null,null,"© Christos Samaras"]
[null,"COMMONPROGRAMFILES","C:\\Program Files (x86)\\Common Files",null,null,"Mechanical Engineer"]
[null,"COMMONPROGRAMFILES(X86)","C:\\Program Files (x86)\\Common Files",null,null,"tel.: +306973513308"]
[null,"COMPUTERNAME","CHRISTOS-PC",null,null,"e-mail: xristos.samaras@gmail.com"]
[null,"COMSPEC","C:\\Windows\\system32\\cmd.exe",null,null,"site: https://www.myengineeringworld.net"]
[null,"HOMEDRIVE","C:",null,null,"Thessaloniki, Greece, 26/05/2014"]
[null,"HOMEPATH","\\Users\\Christos"]
[null,"LOCALAPPDATA","C:\\Users\\Christos\\AppData\\Local"]
[null,"LOGONSERVER","\\\\CHRISTOS-PC"]
[null,"NUMBER_OF_PROCESSORS","8"]
[null,"PROGRAMDATA","C:\\ProgramData"]
[null,"PROGRAMFILES","C:\\Program Files (x86)"]
[null,"PROGRAMFILES(X86)","C:\\Program Files (x86)"]
[null,"PSMODULEPATH","C:\\Windows\\system32\\WindowsPowerShell\\v1.0\\Modules\\;C:\\Program Files (x86)\\Microsoft SQL Server\\110\\Tools\\PowerShell\\Modules\\"]
[null,"PUBLIC","C:\\Users\\Public"]
[null,"SYSTEMDRIVE","C:"]
[null,"SYSTEMROOT","C:\\Windows"]
[null,"TEMP","C:\\Users\\Christos\\AppData\\Local\\Temp"]
[null,"TMP","C:\\Users\\Christos\\AppData\\Local\\Temp"]
[null,"USERDOMAIN","Christos-PC"]
[null,"USERNAME","Christos"]
[null,"USERPROFILE","C:\\Users\\Christos"]
[null,"WINDIR","C:\\Windows"]
[]
[]
[null,"Custom Function Result","Custom Function Description"]
[null,{"$f":"Is64bitOS()","v":true},"Is64bitOS returns TRUE if the operating system (OS) is 64 bit. It uses the PROGRAMFILES(X86) environment variable."]
[null,{"$f":"Is64bitOS2()","v":true},"Is64bitOS2 returns TRUE if the operating system (OS) is 64 bit. It uses the PROGRAMW6432 environment variable."]
[null,{"$f":"Is64bitOS3()","v":true},"Is64bitOS3 returns TRUE if the operating system (OS) is 64 bit. It uses the COMMONPROGRAMFILES(x86) environment variable."]
[null,{"$f":"UserFolder()","v":"C:\\Users\\Christos"},"UserFolder returns the default user folder based on HOMEDRIVE and HOMEPATH environment variables (an alternative to USERPROFILE)."]
[null,{"$f":"MyDesktop()","v":"C:\\Users\\Christos\\Desktop"},"MyDesktop returns the Desktop location based on USERPROFILE environment variable."]
[null,{"$f":"MyDocuments()","v":"C:\\Users\\Christos\\My Documents"},"MyDocuments returns the path of My Documents folder based on USERPROFILE environment variable."]
[null,{"$f":"MyPictures()","v":"C:\\Users\\Christos\\My Pictures"},"MyPictures returns the path of My Pictures folder based on USERPROFILE environment variable."]