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
WorkbookOpen_ANmar
Opens Workbook without running AutoMacros and without letting the user know ...
2018Jun16
CopyFiles Excel-Macro
Simple macro to make sure we have a copy of all files in a folder found in ...
Mar12
IsThere1_Folder
Checks if a folder is found or not, can pass either mapped path or unmapped ...
2018Aug10
FixPath, IsThere, IsThere1 ...
Set of 6 functions to deal with filesystem. Gets current workbook path, ...
2018Jun11
Excel recovered files
Location of Excel recovery workbooks in your system when Excel crashes, it ...
2023Mar31
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
SettingRead_JR
Reads setting saved in columns J:R Just like SettingRead, but when we have ...
2018Jun26
Multi-line Textbox focus bug
Trick to force textbox with multiple lines and scrollbars to refresh itself ...
2018Jun7
CountColumnCells + CountColumnCells_Criteria
Counts how many cells in a column in any sheet, any workbook using COUNTIF ...
2018May23