Set of 6 functions to deal with filesystem. Gets current workbook path, ...
2018Jun11
Creates a zip from folder using 7Z archive. 7za,exe (found in attached zip) ...
2018Jul14
Compress a single file into zip archive using 7Za.exe 7za,exe (found in ...
2018Jul14
Create zip from list of files listed in List_of_Files separated by comma. The ...
2018Jul14
Zipping content of folder into file. Not tested and Not My Work. Originally ...
2023Mar29
Check if an Excel file is running from 'Temp' location or regular folder This ...
2018Jun17
Extract Date from Datetime field in SQL An old method I found in my archive.
Nov29
Creates a thumb of an image using IrfanView Thumbnail filename will have _th ...
2018Jul22
Rotates an image using irfanview (i_view32.exe attached) Rotated image can be ...
2018Jul22
Counts how many cells matching 2 criterias.
Just like
May1
Listing the file from a folder that was created during last few hours. Can ...
Apr30
Show an image using irfanview or Windows 7 image viewer. Looking to add more ...
2020Feb16
A gallery with lightbox, small with no dependencies
LightGallery
2019Jan19
Cuts the left or Middle part of string without breaking words Can specify ...
2018Aug8