RealityCheck

RealityCheck Overview

A Collection of helpful search Functions for checking modules, collections and dynamic string subsections.

IsClassModuleLoaded

Used to check if a workbook has a class module installed. Defaults to current active workbook.

Public Function IsClassModuleLoaded(name As String, Optional wb As Workbook) As Boolean

To Call:

moduleCheck = RealityCheck.IsClassModuleLoaded ("TargetModule")

Returns

Boolean

IsStandardModuleLoaded

Used to check if a workbook has a standard module installed. Defaults to current active workbook.

Public Function IsStandardModuleLoaded(name As String, Optional wb As Workbook) As Boolean

To Call:

moduleCheck = RealityCheck.IsStandardModuleLoaded ("TargetModule")

Returns

Boolean

IsAnyModuleLoaded

Used to check if a workbook has a module installed. Defaults to current active workbook.

Public Function IsAnyModuleLoaded(name As String, Optional wb As Workbook) As Boolean

To Call:

moduleCheck = RealityCheck.IsAnyModuleLoaded ("TargetModule")

Returns

Boolean

InCollection

Used to check if a collection contains a string key.

Public Function InCollection(col As Collection, key As String) As Boolean

To Call:

collectionCheck = RealityCheck.InCollection(myCollection, "myKey")

Returns:

Boolean

ReturnBetweenElements

Used to find the substring between keys.

Public Function ReturnBetweenElements(sConCat As String, sFirstElement As String, sSecondElement As String) As String

To Call:

stringBetweenKeys = RealityCheck.ReturnBetweenElements("garbageHello World!data", "garbage", "data")

Returns:

"Hello World!"

Link to Module

RealityCheck on Github