Recent Microsoft 365 Excel blocked macros from running when they are in ...
Jul10
Set of 6 functions to deal with filesystem. Gets current workbook path, ...
2018Jun11
Automatically save workbook (when using OneDrive) on or off This is the VBA ...
2022Feb23
Checks if ID has been reset in SQL database table If yes, it will reset it and ...
2020Mar31
Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...
2023Mar14
Creates Linkedin profile badge for certain user as HTML output as string. ...
2019Jun28
MinIF to calculate smallest number matching certain criteria, in Excel 2010 ...
2019Feb1
Simple macro to make sure we have a copy of all files in a folder found in ...
Mar12
Counts how many cells matching 2 criterias.
Just like
May1
Listing the file from a folder that was created during last few hours. Can ...
Apr30
Enable relative paths for ASP Classic includes to work. New servers do not ...
Aug7
Removes [Enter]s from imported csv file into Excel worksheet. Smart enough to ...
2018Jul7
Calculate distance between two points (Latitude, Longitude) LatLon1 and ...
2018Jun27