VBA-Excel 352

Visual basic for applications that works only in Microsoft Excel, aka macros
Sorted from new to old.
Card image
WorkbookClose_ANmar

Closes a workbook, checks if it is already open first, works for workbooks ...

Card image
InternationalComma

Convert an international numeric with , instead of . Into American style . ...

Card image
ExportSheets_to_1PDF

Export multiple sheets as pages in 1 pdf doc. Passing list of sheets as ...

Card image
ANmaVBATemplate

Template to be used for any new tools, having... D sheet, WelcomeSheet, code ...

Card image
UnBreakAr + BreakAr

Fix broken Arabic char, by using AscW and ChrW This is Excel User-defined ...

Card image
ImageRotate_IrfanView

Rotates an image using irfanview (i_view32.exe attached) Rotated image can be ...

Card image
CreateThumb_IrfanView

Creates a thumb of an image using IrfanView Thumbnail filename will have _th ...

Card image
CustomExcelMenu - FaceIDs

How to create custom Excel menu, this one shows the IDs and icons of 20 icons, ...

Card image
ExcelMenu_onfly

Creates Excel menu on the fly, list of menu items, command actions, and icons ...

Card image
WorkbookSaveAsk_ANmar

Asks user to save file (or workbook) using GetSaveAsFilename method. Returns ...

Card image
WorkbookOpenAsk_ANmar

Asks user to browse to a file and return full path and file name if they do, ...

Card image
CreateZipFile_7Zip

Compress a single file into zip archive using 7Za.exe 7za,exe (found in ...

Card image
CreateZipFiles_7Zip

Create zip from list of files listed in List_of_Files separated by comma. The ...

Card image
Unzip_7Zip

Extracts a zip into a location and waits for that extraction to finish Using ...

Card image
CreateZipFolder_7Zip

Creates a zip from folder using 7Z archive. 7za,exe (found in attached zip) ...

Card image
FindFile

Finds if a workbook is open or not in same Excel session