Codes recently updated
New versions for codes, updated recently by our developers. 24 most recent codes.
Match4_4thNot0 v3
Searches for three cells in three columns then checks for 4th column if not ...
Nov13
Match3_3rdNot0 v2
Searches for two cells in two columns then checks for 3rd column if not equal ...
Nov13
ANmaHTMLTables_Combine2 v2
Combine strings of two HTML tables into string of one table. Edit 2024-10-31: ...
Oct31
FixPath, IsThere, IsThere1 ... v10
Set of 6 functions to deal with filesystem. Gets current workbook path, ...
Oct31
BrowseWorkbook + BrowseWorkbook_Save v2
Asks for Excel file to open, then return the full filename with path if ...
Oct31
MapPath_SafeComma v2
MapPath version expecting comma in filename or folder. Just because we might ...
Oct26
ANmAddressRefStyle v2
Returns type of the cell address, A1 or R1C1 If multiple cells passed, the ...
Sep29
Q_NoOfdays v2
Calculates number of days for certain quarter, starting from given quarter with ...
Aug24
ExportSheets_to_1PDF v2
Export multiple sheets as pages in 1 pdf doc. Passing list of sheets as ...
Aug15
VBA vs ASP Classic v9
Differences between coding in VB in Classic ASP (aka VBScript) and VBA (aka ...
Aug13
WorkbookOpen_ANmar v3
Opens Workbook without running AutoMacros and without letting the user know ...
Aug13
DosCommand_Read v2
Get output of DOS Command in string, by reading output into temp text file, ...
Aug11
DirsCombo_Read v2
Read directories in a specified folder into a combobox Needs FrmBr having Cbo1
Aug11
HTMLPadding_or_Margin v8
Finds the padding or margin from a style statement for an HTML tag. Passing ...
Aug10
CutLeftNumber v3
Cuts the left part of string as long as it is number Keeps getting characters ...
Aug10
CutString8 v2
Cuts a string from certain character to certain character with option of either ...
Aug3