Codes Required
FixPath, IsThere, IsThere1 ...
Set of 6 functions to deal with filesystem. Gets current workbook path, ...
2018Jun11
Similar codes
Unzip_7Zip
Extracts a zip into a location and waits for that extraction to finish Using ...
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
CreateThumb_IrfanView
Creates a thumb of an image using IrfanView Thumbnail filename will have _th ...
2018Jul22
Files_MostRecentN
Gets most recent N files from a given folder. Uses Arrays, and the function ...
2018Oct1
ImageRotate_IrfanView
Rotates an image using irfanview (i_view32.exe attached) Rotated image can be ...
2018Jul22
FS_CreateUserFolder
Creates a folder for a user, usually after sign up or login for first time
2018Jul9
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
CopyFields_FromTo
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
Random Codes
RandomUniqueID_Sheet
Inserts numeric random unique ID in a column in sheet, specify column, sheet, ...
2021May29
Part of cells in Excel
How to modify part of text inside an Excel cell using VBA. Something in my ...
2020Oct13
ANStrList functions
Set of functions to manage ANStrList strings, read, save, delete, sort, compare, ...
2018Apr14