Monkey Tools

SmartFolder Monkey

Article Overview One of our favourite tricks is to create a “From Folder” solution which avoids hard-coding a file path, instead pulling it dynamically via our fnGetParameter setup. The issue is that this creates a link to either a local or SharePoint / OneDrive for Business folder. However, this causes problems when you open the file in […]

Parameter Table and Function

Article Overview If you’re a fan of the fnGetParameter function (as per Chapter 17 of my Master Your Data book), you’ll love this Monkey. With just a click, it will insert the Parameter Table and fnGetParameter function into your workbook.  It even places the Excel File Path formula in the cell for you! In this article, we’ll explore exactly […]