Similar codes
DB Functions (By AI)
3 functions to add or update data to DB and Read from DB. These were also ...
2023Apr23
SQL Cross Apply String_Split with XML Path
SQL select statement to convert list of IDs found in column (from more than row ...
Jan20
ANmaSQL_InsertStatement
Creates SQL INSERT statements from a table in Excel. Used to be executed to ...
2022Jul3
NextID_Reset
Checks if ID has been reset in SQL database table If yes, it will reset it and ...
2020Mar31
Latest records date and count
Find how many items in table, with column DateAdded is the latest DateAdded in ...
Nov2
RandomRecords
Returns random IDs (or any column) from SQL Database table, passing number of ...
2018Jul29
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 ...
Tue 7AM
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Random Codes
OpenOffice Calc
OpenOffice programming with Visual Basic Some document I had for my reference.
2019Jan5
Page area and Page Setup functions (Unfinished)
Clear Excel print area, or set it, or read it, along with Page setup commands ...
2018Jun30