Codes Required
FixPath, IsThere, IsThere1 ...
Set of 6 functions to deal with filesystem. Gets current workbook path, ...
2018Jun11
Similar codes
CreateZipFiles_7Zip
Create zip from list of files listed in List_of_Files separated by comma. The ...
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
Zip_Folder
Zipping content of folder into file. Not tested and Not My Work. Originally ...
2023Mar29
CreateThumb_IrfanView
Creates a thumb of an image using IrfanView Thumbnail filename will have _th ...
2018Jul22
Execute exe embedded in Excel
Execute exe file that embed inside Excel sheet This is for experimental, not ...
2021Apr16
ImageRotate_IrfanView
Rotates an image using irfanview (i_view32.exe attached) Rotated image can be ...
2018Jul22
WaitFor + ShellWait
Tell App to wait for number of seconds and Execute command and wait for it ...
2018Jun16
Screenshot_IrfanView
Saves a screenshot of the entire screen into a file using IrfanView (i_view32. ...
2019Jun27
Recently by developer
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
May1
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Apr30
Random Codes
FilterSheet_1By1 + FilterSheet_Clear
Sets Autofilter in a sheet, and another function to clear Autofilter ...
2020Jan3
