Posts

Showing posts from July, 2023

Excel VBA GUID Encoder

Attribute VB_Name = "CharEncode" '''Back-end VBA Excel parameter manager '''Updated 2023-09-29 failover for parameters accidentally using 5-9 (e.g. dates) in parameter encode; '''option LockBITc to FORCE bit depth to stay at 5 (Chars 5-9 would show as "." - bad for date-types) '''force UPPERCASE for 5 bit '''UPDATED 2023-07-13 reference verified for current encoding. ''(c)2021 Ron E. Allen- Shared with KTGY2018-2019 - All rights reserved ''2020-08-30-shared with KTGY provided credit is provided for original works. ''Total hack- BUT it works to jam 21 characters using a 6 bit reference ''into a 128bit GUID ''Characters register 6 bit binary MSB at left, ''every 8 bits gets jammed into a HEX and those bits removed off the stack ''when max characters is reached- there are 2 bits left over - filled with ''LSB "00" to force the HEX to