Similar codes
ReadLastChars
Reads last some characters of a file, needs to see contents of large files that ...
2023Apr20
SharePointURL2Path + Path2SharePointURL
Converts SharePoint URL to regular folder path and the other way, giving the ...
2018Jun30
OpenPassword + ClosePassword
Encrypt / Decrypt a string, convert it to "77 96 105 105 106" or back to ...
2018Jun14
Paragraph2Line + Line2Paragraph
Converts paragraph to 1 line text or 1 line text to paragraph Mainly used to ...
2018Jun2
ANma_HTML2DB + ANma_DB2HTML + ...
Convert HTML text into DB-safe string, by converting some characters as below. ...
2019Feb7
SwitchTextinCells
Switch text inside cells with another text. This was needed to correct an bug ...
Feb23
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
Copy formulas
How to copy formulas in VBA code. Learned that the hard way, just like most of ...
2019Oct3
Temporary folder in Win10
Where is the Temp folder in Windows 10? Since Windows 7, it has been in the ...
2019Apr9
FormatMyDate
Formats a date, equivalent to VB6 function 'Format' Also with it, you will ...
2019Jan4
