Similar codes
DB Functions (By AI)
3 functions to add or update data to DB and Read from DB. These were also ...
2023Apr23
Records Affected by Execute command
Records affected by sql Execute command https://docs.microsoft. ...
2018Sep1
RandomRecords
Returns random IDs (or any column) from SQL Database table, passing number of ...
2018Jul29
NextID_Reset
Checks if ID has been reset in SQL database table If yes, it will reset it and ...
2020Mar31
ANmaSQL_InsertStatement
Creates SQL INSERT statements from a table in Excel. Used to be executed to ...
2022Jul3
Reset ID Column
How to reset ID Column in Microsoft SQL, (not completed yet). This is because ...
2020Feb9
SQL Cross Apply String_Split with XML Path
SQL select statement to convert list of IDs found in column (from more than row ...
Jan20
InSheet_ChangeImage
Allows users to inserts image into sheet, replacing old one, with ability to ...
2021Feb20
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
ServerXMLHTTP stream
Using ServerXMLHTTP object to show (stream or download) and image , or any ...
2021Aug3
Resize_Me2 + Resize_Me3
Resizes Excel window to certain small size and location (hard-coded) and hide ...
2020Dec11
