Codes Required
GetFilename, GetExtension, .. others
GetFilename, GetExtension, GetFilename_noExtension, GetFilename_wExtension To ...
2018Jun11
Similar codes
WorkbookClose_ANmar
Closes a workbook, checks if it is already open first, works for workbooks ...
2018Aug9
CreateThumb_IrfanView
Creates a thumb of an image using IrfanView Thumbnail filename will have _th ...
2018Jul22
SheetAdd_ANmar
Adds a sheet to a workbook, after checking if workbook is open Checks if ...
2019Apr1
Generate_PowerPoint
Creates PowerPoint slideshow file from Excel range(s) with slide per sheet (or ...
2020Dec22
WorkbookSave_ANmar
Saves a workbook handling several scenarios and decide what to do based on each. ...
Aug9
AutoSaveOn
Automatically save workbook (when using OneDrive) on or off This is the VBA ...
2022Feb23
Screenshot_IrfanView
Saves a screenshot of the entire screen into a file using IrfanView (i_view32. ...
2019Jun27
IsThere1_SPWB
Checks if a workbook is found in a SharePoint location or not, giving a full ...
2020Apr1
WorkbookSaveAsk_ANmar
Asks user to save file (or workbook) using GetSaveAsFilename method. Returns ...
2018Jul17
Recently by developer
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
May1
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Apr30
Random Codes
Fancybox iframe
This is to demonstrate how to call a Fancybox from inside an iframe into parent ...
2019Jan15
Folder Space used
Get sizes of each folder next to the asp file FolderSpace.asp. Then total of ...
2018Dec9
