Similar codes
SharePointURL2Path + Path2SharePointURL
Converts SharePoint URL to regular folder path and the other way, giving the ...
2018Jun30
WorkbookClose_ANmar
Closes a workbook, checks if it is already open first, works for workbooks ...
2018Aug9
SheetAdd_ANmar
Adds a sheet to a workbook, after checking if workbook is open Checks if ...
2019Apr1
FixPath, IsThere, IsThere1 ...
Set of 6 functions to deal with filesystem. Gets current workbook path, ...
2018Jun11
CopyFiles Excel-Macro
Simple macro to make sure we have a copy of all files in a folder found in ...
Mar12
Recently by developer
ANmAddress_Value
Returns the value of a cell address in another sheet. Todo: Allow to reference ...
Thu 11AM
JSon functions to add, read and delete entry
3 Json functions to read full node by an image, add full node to file or delete ...
Tue 12PM
GetPapa + GetSon with variances
Gets the parent folder full name from a path Also Gets the son of a full path. ...
Sat 11AM
HTMLTable_NoOfColumns
Gets no of columns in an HTML table. It actually gets the maximum number of ...
Sat 11AM
Random Codes
ANmaCellChar_Superscript_Subscript
Sets certain character inside a cell as superscript or subscript
Aug11
DB_AllRows
Returns all rows found from an SQL Query as string Separated by row and column ...
2018Apr23
MyMonthName
Returns the month name in one of 5 formats (below) It can use full date or ...
2018Apr21