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
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Apr30
Random Codes
Shape_Select_or_CreateThenSelect
Selects a shape inside sheet to change it, or if not found, it will create it ...
2022Jul21
Evaluate
Execute any command in Excel VBE, using Application.Evaluate to execute almost ...
2020Feb16
