Components 59

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

Page2Setting

Read content of an html online page into setting value in Excel sheet. ...


SheetDelete_ANmar

Deletes a sheet from a workbook, checks it is already there first


CellSave_Hyperlink

Creates a hyperlink to URL or to cell inside a cell in Excel VBA (or delete it). ...


FindFile_Word

Finds a file within open documents of current instance


WorkbookNew_ANmar

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


WorkbookClose_ANmar

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


List_Load + List_Save

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


sortArray

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


Shapes-Macros

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


IIF

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


FindVBAObject

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


oShellRun1

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