Codes Required
Converts two bytes to long
Functions to convert two bytes to a numeric value (long), (both little-endian ...
Jan14
ChartLabelsNumberFormat
Apply Number format of 1 decimal to datalabels of specific series in certain ...
Dec23
Arr_1Dim_2Str
Converts 1-dimension array into text. Meet Join. A way to convert array into ...
Aug14
Total14Round
Round time to Hours:Minutes format regardless of number of days Like in 80:40. ...
Aug8
ANmaSQL_InsertStatement
Creates SQL INSERT statements from a table in Excel. Used to be executed to ...
2022Jul3
IsThere1_SPWB
Checks if a workbook is found in a SharePoint location or not, giving a full ...
2020Apr1
FilterSheet_1By1 + FilterSheet_Clear
Sets Autofilter in a sheet, and another function to clear Autofilter ...
2020Jan3
ANmaDB functions
Database functions, commonly used in my systems. Should be working for each ...
2019Apr14
IsThere1_Folder
Checks if a folder is found or not, can pass either mapped path or unmapped ...
2018Aug10
Encrypt1 + Decrypt1
Encrypts (and decrypts) a string. To decrypt an encrypted string, use the ...
2018Jul25
CutString1
Cuts a string from a string starting from a specific character index and until ...
2018Jul11
oShellRun1
Runs a WScript.Shell command with wait until finish and returns 0, 1, 2 or -1 ...
2018Jul6
ANBS controls
Set of functions to generate Bootstrap controls as strings. Controls available ...
2018Jun24
DB_Read1Row (DB_Read1stRow)
Reads from a table in a DB Reads only the first row, and return a string ...
2018Apr21
Similar codes
VBA Progressbar (Frm73)
Progress bar Frm73 or just simple message Zip file contains .frm and .frx ...
2018May16
Circular Loader
Jquery driven loader, progressbar or graph, nice with some options to customize
2019Feb13
Toggle navbar with Slide Down Animation
TOggle Navbar to show, login form, another list of links, search bar, or ...
2020Jul30
MoveDown + MoveUp
Moves an item in listbox up or down Needs Lst1 as listbox name Put code ...
2018Jun2
percircle ProgressCircle
A neat progress circle (progressbar) using CSS and JQuery Used in this ...
2019Jan20
Recently by developer
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Tue 8AM
SettingSave + SettingRead for NumberFormat
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
ANmaCellFormat
Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...
Apr18
CopyFields_FromTo
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
Random Codes
List of Databases
Script to list databases available in a server using ADODB connection
From
2019Oct6
FileDateTime
Gets time and date for a file, Date created, accessed or modified. If the file ...
2018Jul5