Most of the services accept a Workbook argument which is either a Workbook object, a Workbook's FullName or a Workbook's Name. All services provide a comprehensive inline documentation.
Name | Service |
---|---|
Value | Let: Writes a value to a named range Get: Returns a value from a named range |
WbClose | Closes a Workbook if it is open. |
Exists | Universal existence check for Workbook, worksheet, and Range Name. An existing and open Workbook is returned as Workbook object, an existing Worksheet is returned as Worksheet object |
GetOpen | Opens a Workbook and returns it as Workbook object |
IsFullName | Returns TRUE when a provided string represents a Workbook's FullName whereby the Workbook must neither be open nor existent. |
isName | Returns TRUE when a provided string represents a Workbook's Name |
IsWbObject | Returns TRUE when a provided argument represents a Workbook object |
IsWsObject | Returns TRUE when a provided argument represents a Workbooks Worksheet either by its Name or _by its _CodeName |
IsOpen | Returns TRUE when a provided argument identifies an open Workbook whereby the open Workbook is retrurned as Workbook object |
Opened | Returns a Dictionary with all open Workbooks in all application instances. |
Download and import mWbk.bas
This Common Component is prepared to function completely autonomously ( download, import, use) but at the same time to integrate with my personal 'standard' VB-Project design. See Conflicts with personal and public Common Components for more details.
Any kind of contribution is absolutely and unconditionally welcome.