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
Wed 7AM
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Tue 7AM
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Random Codes
Calendar, a pure-VBA userform (FrmCal)
VBA pure Calendar form, no outside lib needed Edit 2020-03-18: Enhance ...
2018May16