Similar codes
SQL Date from DateTime
Extract Date from Datetime field in SQL An old method I found in my archive.
Nov29
VBInstr (or Instr parameters)
The great function InStr I use a lot has a small confusing part. Which string ...
2019Jan9
DB_AllRows
Returns all rows found from an SQL Query as string Separated by row and column ...
2018Apr23
Records Affected by Execute command
Records affected by sql Execute command https://docs.microsoft. ...
2018Sep1
Random Number in SQL
Generate Random number inside SQL using timestamp (GetDate function) One of ...
Jan30
InStr and InStrRev
How to use InStr and InStrRev VB functions It is silly, I know, but I keep ...
2021Dec6
CutString8
Cuts a string from certain character to certain character with option of either ...
2021May29
Recently by developer
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
May1
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Apr30
Random Codes
AutoSaveOn
Automatically save workbook (when using OneDrive) on or off This is the VBA ...
2022Feb23
FGColor_Calc
To set the color of the foreground based on background color to get best look. ...
2018Jun20
ANStrRead + ANStrSave + ANStrSearch
Reads and saves data into 1 dim string array, ANStr ANStr is a string of list ...
2018Jun14