VBA-Excel 97 VBA that works only in Excel

Card image cap
ExcelMenu_onfly

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

Card image cap
WorkbookSaveAsk_ANmar

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

Card image cap
WorkbookOpenAsk_ANmar

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

Card image cap
CreateZipFile_7Zip

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

Resources.zip

Card image cap
CreateZipFiles_7Zip

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

Resources.zip

Card image cap
Unzip_7Zip

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

Resources.zip

Card image cap
CreateZipFolder_7Zip

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

Resources.zip

Card image cap
FindName

Finds if a name (Range name) is found in a certain workbook or not Workbook is ...

Card image cap
FindFile

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

Card image cap
ConvertMultiLine2 + 6

Convert text blocks (by converting line separators from any separator to any). ...

Card image cap
Shapes-Macros

Read shapes in all worksheets in certain workbook and return list of macros ...

Shapes-Macros v1.0.xlsb.zip

Card image cap
WelcomeSheet

A User-Friendly way to ask user to enable macros. Showing an only sheet to let ...

WelcomeSheet.zip