Components 68 Controls, objects and classes, also cells, sheets, workbooks in VBA-Excel

Card image cap
FindFile_Word

Finds a file within open documents of current instance

Card image cap
WorkbookNew_ANmar

Creates new workbook (does not save it) and returns filename.

Card image cap
WorkbookClose_ANmar

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

Card image cap
List_Load + List_Save

Loads/Saves items from/to text file to/from listbox Also has simple adding and ...

Card image cap
sortArray

Sort an array of Numeric values, simple straightforward Originally from ...

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
IIF

[Not tested] Works the same as it's VB IIF equivalent. IIf will coerce an ...

Card image cap
FindVBAObject

Finds specific VBA object in VBE project User need to setup to trust VBA ...

Card image cap
oShellRun1

Runs a WScript.Shell command with wait until finish and returns 0, 1, 2 or -1 ...

Card image cap
SortArea5

Sort range or area by 5 columns, range can be any number of columns, but the ...

Card image cap
ServerVar

Get value of Server variable by passing variable name aVar can be any of these ...

Card image cap
SortArea3

Sort range or area by 3 columns, range can be any number of columns, but the ...