Codes Required
FixPath, IsThere, IsThere1 ...
Set of 6 functions to deal with filesystem. Gets current workbook path, ...
2018Jun11
Similar codes
CreateZipFolder_7Zip
Creates a zip from folder using 7Z archive. 7za,exe (found in attached zip) ...
2018Jul14
CreateZipFile_7Zip
Compress a single file into zip archive using 7Za.exe 7za,exe (found in ...
2018Jul14
CreateZipFiles_7Zip
Create zip from list of files listed in List_of_Files separated by comma. The ...
2018Jul14
Zip_Folder
Zipping content of folder into file. Not tested and Not My Work. Originally ...
2023Mar29
RunFromTemp
Check if an Excel file is running from 'Temp' location or regular folder This ...
2018Jun17
SQL Date from DateTime
Extract Date from Datetime field in SQL An old method I found in my archive.
Nov29
CreateThumb_IrfanView
Creates a thumb of an image using IrfanView Thumbnail filename will have _th ...
2018Jul22
ImageRotate_IrfanView
Rotates an image using irfanview (i_view32.exe attached) Rotated image can be ...
2018Jul22
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
UnUnixDateTime
Convert a number represents a date in Unix format back into date, opposite of ...
Jan6
Bootstrap 5 cards with responsive images
Bootstrap 5 cards with responsive images
From
Nov24
SwapNumbers
Swap two numbers variables without using third variable A trick worth saving ...
2022Oct17
GetFilename, GetExtension, .. others
GetFilename, GetExtension, GetFilename_noExtension, GetFilename_wExtension To ...
2018Jun11