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 ...
Apr30
Random Codes
UnixDateTimeNumber
Calculates Unix date/time number of a given date/time. Needed it to pass ...
2023Jan6
Loading gif
Show and hide loading gif using Javascript. a simple way to control when to ...
2018Sep23