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
Wed 7AM
Listing the file from a folder that was created during last few hours. Can ...
Tue 7AM
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Bootstrap 5 cards with responsive images
From
Nov24
Count how many files in a folder, with no loop, faster if you just need all ...
2019Feb2