GetFilename, GetExtension, GetFilename_noExtension, GetFilename_wExtension To ...
2018Jun11
Closes a workbook, checks if it is already open first, works for workbooks ...
2018Aug9
Creates a thumb of an image using IrfanView Thumbnail filename will have _th ...
2018Jul22
Adds a sheet to a workbook, after checking if workbook is open Checks if ...
2019Apr1
Creates PowerPoint slideshow file from Excel range(s) with slide per sheet (or ...
2020Dec22
Saves a workbook handling several scenarios and decide what to do based on each. ...
Aug9
Automatically save workbook (when using OneDrive) on or off This is the VBA ...
2022Feb23
Saves a screenshot of the entire screen into a file using IrfanView (i_view32. ...
2019Jun27
Checks if a workbook is found in a SharePoint location or not, giving a full ...
2020Apr1
Asks user to save file (or workbook) using GetSaveAsFilename method. Returns ...
2018Jul17
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
Reads image dimensions, width, height, depth and image type. Details returned ...
Jan16
Clean filename from special characters to make it safe for server upload Then ...
2019Dec10
Saves a screenshot of the entire screen into a file using IrfanView (i_view32. ...
2019Jun27