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
Random Codes
SheetAdd_ANmar
Adds a sheet to a workbook, after checking if workbook is open Checks if ...
2019Apr1
WelcomeSheet
A User-Friendly way to ask user to enable macros. Showing an only sheet to let ...
2018Jul9
WorkbookOpen_ANmar
Opens Workbook without running AutoMacros and without letting the user know ...
2018Jun16