Converts SharePoint URL to regular folder path and the other way, giving the ...
2018Jun30
Closes a workbook, checks if it is already open first, works for workbooks ...
2018Aug9
Adds a sheet to a workbook, after checking if workbook is open Checks if ...
2019Apr1
Opens Workbook without running AutoMacros and without letting the user know ...
2018Jun16
Simple macro to make sure we have a copy of all files in a folder found in ...
Mar12
Checks if a folder is found or not, can pass either mapped path or unmapped ...
2018Aug10
Set of 6 functions to deal with filesystem. Gets current workbook path, ...
2018Jun11
Location of Excel recovery workbooks in your system when Excel crashes, it ...
2023Mar31
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Listing the file from a folder that was created during last few hours. Can ...
Tue 7AM
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Looks like we cannot have filename (having no extension) and folder in same ...
Mar5
Gets the cell row where a certain shape is located by passing shape.Top number ...
2021Feb2
Checks if URL is actually working. Uses XMLHTTP object to see if that URL ...
2018Dec9
Reads everything in a column (starting from certain cell until blank cell is ...
2018Jun10