Similar codes
ANmaCellFormat
Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...
Apr18
Files_MostRecentN
Gets most recent N files from a given folder. Uses Arrays, and the function ...
2018Oct1
ImagesIn_User
Gets images in a folder where filenames start with "User" Similar to function ...
2019Dec31
strUnQuote
This will tests to see if strQuotedString is wrapped in quotation marks, and, ...
2018Jul3
Concatenate_HTMLColumn
Build a string from a certain column in html table (using < table, < tr, and < ...
Mar14
TeeOpen_ProtectTee + TeeOpen_UnprotectTee
Protect or unprotect a workbook (already open) remotely from another workbook ...
2019Jun2
HTMLTag + HTMLPair
Generate HTML tags with thier parameters as name=value pairs ' Example of ...
2018Jun30
CellSave_Hyperlink
Creates a hyperlink to URL or to cell inside a cell in Excel VBA (or delete it). ...
2018Aug9
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
List of Databases
Script to list databases available in a server using ADODB connection
From
2019Oct6
Slider (Bootstrap)
A nice bootstrap slider
From
2019Jun20
RunFromTemp
Check if an Excel file is running from 'Temp' location or regular folder This ...
2018Jun17