Codes Required
Similar codes
SheetAdd_ANmar
Adds a sheet to a workbook, after checking if workbook is open Checks if ...
2019Apr1
IsThere1_SPWB
Checks if a workbook is found in a SharePoint location or not, giving a full ...
2020Apr1
WorkbookOpen_ANmar
Opens Workbook without running AutoMacros and without letting the user know ...
2018Jun16
WorkbookSave_ANmar
Saves a workbook handling several scenarios and decide what to do based on each. ...
Aug9
Frm9 - Select workbook (or workbook/worksheet)
Gives your user ability to select a workbook from list of open workbooks within ...
2019Apr3
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
Excel recovered files
Location of Excel recovery workbooks in your system when Excel crashes, it ...
2023Mar31
FixENTERS_File
Removes [Enter]s from imported csv file into Excel worksheet. Smart enough to ...
2018Jul7
DB_Read1Row (DB_Read1stRow)
Reads from a table in a DB Reads only the first row, and return a string ...
2018Apr21