Codes Required
IsThere1_SPWB
Checks if a workbook is found in a SharePoint location or not, giving a full ...
2020Apr1
IsThere1_Image
Searches for an image and return the file extension of found, or returns null ...
2019Dec7
IsThere1_Folder
Checks if a folder is found or not, can pass either mapped path or unmapped ...
2018Aug10
FixPath, IsThere, IsThere1 ...
Set of 6 functions to deal with filesystem. Gets current workbook path, ...
2018Jun11
Similar codes
CreateZipFile_7Zip
Compress a single file into zip archive using 7Za.exe 7za,exe (found in ...
2018Jul14
Unzip_7Zip
Extracts a zip into a location and waits for that extraction to finish Using ...
2018Jul14
CreateZipFolder_7Zip
Creates a zip from folder using 7Z archive. 7za,exe (found in attached zip) ...
2018Jul14
CreateThumb_IrfanView
Creates a thumb of an image using IrfanView Thumbnail filename will have _th ...
2018Jul22
Zip_Folder
Zipping content of folder into file. Not tested and Not My Work. Originally ...
2023Mar29
FilesIn + FilesIn_Count
Returns list of files found in a folder, list separated with custom separator
2018Apr23
FilesIn + FilesIn_Count
Returns list of files found in a folder, list separated with custom separator ...
2018May22
Filename_Clean
Returns cleaned file name of invalid characters. Needs to be modified if used ...
2023Jan11
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
CSS 3D flip
Flip box, 3D in CSS
From
Nov9
ShapeRange_BG
Replaces the background fill of any shape in Excel with an image Not Ready yet, ...
2021Mar27
