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
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Tue 8AM
SettingSave + SettingRead for NumberFormat
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
ANmaCellFormat
Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...
Apr18
Random Codes
AddressReferenceStyle
Change Address style from R1C1 to A1 or from A1 to R1C1. Something I needed ...
Nov1
ReadBinaryChunk
Reads certain chunk of a file in binary. Used with large files (like ~7gb ...
2023Apr28
This Year
A quick JS way to get the year of today, a method found it online, and wanted ...
2018Dec16
