Similar codes
SheetAdd_ANmar
Adds a sheet to a workbook, after checking if workbook is open Checks if ...
2019Apr1
Import_CSV
Import the CSV file, DOES NOT OPEN, Open does not fix encoding issue, import ...
2018Jul7
TeeOpen_ProtectTee + TeeOpen_UnprotectTee
Protect or unprotect a workbook (already open) remotely from another workbook ...
2019Jun2
CountColumnCells + CountColumnCells_Criteria
Counts how many cells in a column in any sheet, any workbook using COUNTIF ...
2018May23
WorkbookClose_ANmar
Closes a workbook, checks if it is already open first, works for workbooks ...
2018Aug9
FixENTERS_File
Removes [Enter]s from imported csv file into Excel worksheet. Smart enough to ...
2018Jul7
Frm9 - Select workbook (or workbook/worksheet)
Gives your user ability to select a workbook from list of open workbooks within ...
2019Apr3
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
FindAncherURL_InHTMLRow
Finds the URL (href tag value) for an anchor inside a table row (tr element) ...
Mar4
Steps Recorder Win10 app
Win10 application already found in Windows. to generate list of steps with ...
Feb16
ServerXMLHTTP stream
Using ServerXMLHTTP object to show (stream or download) and image , or any ...
2021Aug3
ANmaDB functions
Database functions, commonly used in my systems. Should be working for each ...
2019Apr14