Codes Required
SettingRead_Ajax + SettingRead_Ajax_IntoObject
Two functions to return an output of file into object on page or back to caller ...
Jan12
ANmaCopy_Objects
Copies objects from cell into cell Decide Sheet, and workbooks to copy from or ...
2020Nov11
Similar codes
NextID_Reset
Checks if ID has been reset in SQL database table If yes, it will reset it and ...
2020Mar31
DB_ExtendedProperties
Returns extended properties of a database, knowing the ADODB connection
2019Jul22
MSSQL backup
The practical way I found to backup database (or tables) to be moved into new ...
2019Jan6
List of Databases
Script to list databases available in a server using ADODB connection
From
2019Oct6
RandomRecords
Returns random IDs (or any column) from SQL Database table, passing number of ...
2018Jul29
DB_Read1Row (DB_Read1stRow)
Reads from a table in a DB Reads only the first row, and return a string ...
2018Apr21
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
gsplit usage
How to use gsplit to split large files into smaller parts to allow to read it. ...
Feb7
