Codes Required
FixPath, IsThere, IsThere1 ...
Set of 6 functions to deal with filesystem. Gets current workbook path, ...
2018Jun11
GetPapa, GetPapa_URL, GetPapa_Sep, GetSon, GetSon_
Gets that parent folder name giving a full path, or gets the child folder, Can ...
2018May22
Similar codes
FixPath, IsThere, IsThere1 ...
Set of 6 functions to deal with filesystem. Gets current workbook path, ...
2018Jun11
OneDrive Reset
Reset OneDrive because I am a heavy OneDrive user. Most recent instructions, ...
Mar5
IsThere1_Folder
Checks if a folder is found or not, can pass either mapped path or unmapped ...
2018Aug10
WorkbookSaveAsk_ANmar
Asks user to save file (or workbook) using GetSaveAsFilename method. Returns ...
2018Jul17
WorkbookOpenAsk_ANmar
Asks user to browse to a file and return full path and file name if they do, ...
2018Jul17
AutoSaveOn
Automatically save workbook (when using OneDrive) on or off This is the VBA ...
2022Feb23
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
Between2int and Between2intinc
Checks if number between two numbers, with or without considering those numbers. ...
Mar23
PivotTable_ShowHideBlankItems
Shows or hides an item or items in a PivotTable filter field. Passing ...
Jan22
Range22DimArray
Imports a range into 2-dimension array. Returns the array, providing range, ...
May11
UnMergeFill
Unmerges all merged cells and duplicate cell contents into them. In another ...
2019Apr16