XLL+ Class Library

CXlMacros class

The CXlMacros class contains wrapper functions for almost all the built-in Excel macro functions. The wrapper functions take care of converting arguments and results to and from CXlOper objects.

Methods

The built-in Excel macro functions include many useful functions, including:

MethodDescription
GetFormula Returns the contents of a cell as they would appear in the formula bar
Formula Enters a formula in the active cell or in a reference
FormulaFill Enters a formula in the range specified or in the current selection
FormulaArray Enters a formula as an array formula in the range specified or in the current selection
GetActiveWorkbookName Returns the name of the active workbook
GetActiveWorksheetName Returns the name of the active worksheet
WorkbookGetWorksheetNames Returns a list of all the sheets in a workbook

Method names

The names of CXlMacros methods generally reflect their names in the Excel Macro Language (XLM4). This is for the convenience of programmers familiar with the language. If you do not know which is the right method to use, browse the list of methods in CXlMacros methods, and see the detailed examples in the following topics.

Example

See the CallExcel sample for examples of using CXlMacros class.

Next: Using references >>