Create Folder Recursively with Excel VBA January 31, 2021 How to: create folders recursively using VBA code in Excel. Read More
Weighted Moving Average (WMA) January 24, 2021 The Weighted Moving Average (WMA) is a smoothing calculation which like the Exponential Moving Average (EMA) applies greater weighting to more recient data but unlike the EMA is not cumulative. Read More
Open Explorer and select file in Excel VBA January 17, 2021 How to: open an Explorer window so a user can select a file in Excel VBA. Read More
SAS Remove Special Characters from String January 10, 2021 How to: check for, identify and remove non-alphanumeric characters when working with strings in SAS base code. About The below SAS code is one… Read More
Clear RAM (Garbage Collection) in Python January 1, 2021 Clear RAM usage at run time in Python with this function and optionally print the remining RAM usage. Helpful when executing code in loops… Read More