Codes Required
Macro keyboard shortcuts
Assign certain keyboard shortcut to certain macro, or clear that shortcut. ...
Dec13
Associate_Ext
Register an extension in Windows registry for extension with an application. ...
Nov25
ReadLastChars
Reads last some characters of a file, needs to see contents of large files that ...
2023Apr20
LastRow_Remove
Removes last row in a table starting certain cell. Creating and using this ...
2022Aug16
ANmaSQL_UpdateDateStatement
Creates "Update Table " SQL statements to be executed inside SQL to modify ...
2022Jul4
ANmaSQL_InsertStatement
Creates SQL INSERT statements from a table in Excel. Used to be executed to ...
2022Jul3
ASPUsers
Show ActiveUsers in webpage using ASP Classic, this also works as an example of ...
2022May4
ListBox_SelectionCount
Counts how many items selected in a listbox (multi-selection listbox). Works ...
2022Apr21
Range_SaveAsImage
Exports range to an image, something we wanted to be able to do for a while now. ...
2022Feb16
SaveAsHTML_Template
Creates HTML file using template found in a column. Have lines of HTML in a ...
2022Feb5
ListBox_Excel_Sort
Sort items in Fm20 Listbox using Excel spreadsheet Sort function. Can decide ...
2020Sep21
LastInsertedID_SQL
Get the ID of the last inserted record in a table. There are other methods, ...
2019Jul18
MatchLastIf
Finds last occurrence of a match in a column Finds the row of last time an ...
2019Jun12
Base64encode + Base64decode
Encodes and decodes a string, Base64 is used to convert binary data (like ...
2018Jul31
WorkbookSaveAsk_ANmar
Asks user to save file (or workbook) using GetSaveAsFilename method. Returns ...
2018Jul17
WorkbookOpenAsk_ANmar
Asks user to browse to a file and return full path and file name if they do, ...
2018Jul17
ANBS controls
Set of functions to generate Bootstrap controls as strings. Controls available ...
2018Jun24
RemoteExplorer.asp
A directory Viewer with the option of downloading the file and reading text ...
2018Apr23
Similar codes
List of options (Frm87)
Show list of items with their description from "Settings" sheet Have that list ...
2018May17
Files_MostRecentN
Gets most recent N files from a given folder. Uses Arrays, and the function ...
2018Oct1
SettingSave + SettingRead for NumberFormat
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
TeeOpen_ProtectTee + TeeOpen_UnprotectTee
Protect or unprotect a workbook (already open) remotely from another workbook ...
2019Jun2
SettingRead+SettingSave
This is the final version of my set of Setting functions SettingRead, ...
2018Apr27
ANmaCellFormat
Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...
Apr18
strUnQuote
This will tests to see if strQuotedString is wrapped in quotation marks, and, ...
2018Jul3
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
Sorting Strings
This is not a function as much as a note. I needed to force a line to show at ...
2020Jul22
