XLL+ Class Library

CXlMacros Methods

The methods of the CXlMacros class are listed here.

Command-equivalent Macro Functions

public methodpublic methodActivateSwitches to a window
public methodpublic methodActivateNextSwitches to the next window or switches to the next sheet in a workbook
public methodpublic methodActivatePrevSwitches to the previous window or switches to the previous sheet in a workbook
public methodpublic methodActiveCellFontEquivalent to formatting individual characters in a cell
public methodpublic methodAddinManagerAdds or removes an add-in from the working set
public methodpublic methodAlignmentAligns the contents of the selected cells
public methodpublic methodAppMaximizeMaximizes the Microsoft Excel window
public methodpublic methodAppMinimizeMinimizes the Microsoft Excel window
public methodpublic methodAppMoveMoves the Microsoft Excel window
public methodpublic methodAppRestoreRestores the Microsoft Excel window
public methodpublic methodAppSizeResizes the Microsoft Excel window
public methodpublic methodApplyStyleApplies a previously defined style to the current selection
public methodpublic methodBorderAdds a border to the selected cell or range of cells
public methodpublic methodCalculateDocumentCalculates only the active worksheet
public methodpublic methodCalculateNowCalculates all sheets in all open workbooks
public methodpublic methodCellProtectionAllows you to control cell protection and display
public methodpublic methodClearClears contents, formats, notes, or all of these from the active worksheet
public methodpublic methodCloseCloses the active window
public methodpublic methodCloseAllEquivalent to choosing the Close All command from the File menu
public methodpublic methodColumnWidthChanges the width of the columns in the specified reference
public methodpublic methodCopyEquivalent to choosing the Copy command from the Edit menu
public methodpublic methodCutEquivalent to choosing the Cut command from the Edit menu
public methodpublic methodDataSeriesEquivalent to choosing the Series command from the Fill submenu on the Edit menu
public methodpublic methodDefineNameDefines a name on the active sheet
public methodpublic methodDeleteNameDeletes the specified name
public methodpublic methodEditDeleteRemoves the selected cells from the worksheet and shifts other cells to close up the space
public methodpublic methodFileCloseCloses the active workbook
public methodpublic methodFileDeleteDeletes a file from the disk
public methodpublic methodFillAutoEquivalent to copying cells or automatically filling a selection by dragging the fill selection handle with the mouse
public methodpublic methodFillDownCopies the contents and formats of the cells in the top row of a selection into the rest of the rows in the selection
public methodpublic methodFillLeftCopies the contents and formats of the cells in the right column of a selection into the rest of the columns in the selection
public methodpublic methodFillRightCopies the contents and formats of the cells in the left column of a selection into the rest of the columns in the selection
public methodpublic methodFillUpCopies the contents and formats of the cells in the bottom row of a selection into the rest of the rows in the selection
public methodpublic methodFillGroupCopies the contents of the active worksheet's selection to the same area on all other worksheets in the group
public methodpublic methodFontPropertiesEquivalent to choosing the Cells command from the Format menu
public methodpublic methodFormatNumberEquivalent to choosing the Number tab in the Format Cells dialog box
public methodpublic methodFormulaFillEnters a formula in the range specified or in the current selection
public methodpublic methodFormulaReplaceFinds and replaces characters in cells on your worksheet
public methodpublic methodFullScreenEquivalent to choosing the Full Screen command from the View menu
public methodpublic methodGoalSeekEquivalent to choosing the Goal Seek command from the Tools menu
public methodpublic methodHideHides the active window
public methodpublic methodHLineScrolls through the active window by a specific number of columns
public methodpublic methodHPageScrolls through the active window by a specific number of columns
public methodpublic methodHScrollHorizontally scrolls through the active sheet by percentage or by column number
public methodpublic methodInsertInserts a blank cell or range of cells or pastes cells from the Clipboard into a sheet
public methodpublic methodJustifyRearranges the text in a range so that it fills the range evenly
public methodpublic methodLinksReturns the names of all workbooks referred to by external references in the workbook specified
public methodpublic methodNewDefaultWorkbookCreates a new workbook containing the default number of worksheets
public methodpublic methodNewSingleSheetWorkbookCreates a new workbook containing a single worksheet
public methodpublic methodNewWindowCreates a new window for the active workbook
public methodpublic methodNoteCreates a note or replaces characters in a note
public methodpublic methodOpenOpens an existing workbook
public methodpublic methodOptionsCalculationControls when and how formulas in open workbooks are calculated
public methodpublic methodPasteEquivalent to choosing the Paste command from the Edit menu
public methodpublic methodPasteSpecialEquivalent to choosing the Paste Special command from the Edit menu
public methodpublic methodQuitQuits Microsoft Excel and closes any open documents
public methodpublic methodRowHeightChanges the height of the rows in a reference
public methodpublic methodSaveSaves the active document
public methodpublic methodSaveAsEquivalent to choosing the Save As command from the File menu
public methodpublic methodSaveCopyAsSaves a copy of the current document using a different name but all the current document settings, such as passwords and file protection
public methodpublic methodSelectEquivalent to selecting cells or changing the active cell
public methodpublic methodSelectAllEquivalent to selecting all the sheets in a workbook
public methodpublic methodShowActiveCellScrolls the active window so the active cell becomes visible
public methodpublic methodStandardWidthSets the default width used for all columns in a worksheet
public methodpublic methodSummaryInfoGenerates the summary information for the active workbook
public methodpublic methodUndoEquivalent to choosing the Undo command from the Edit menu
public methodpublic methodUnhideEquivalent to choosing the Unhide command from the Window menu
public methodpublic methodVLineScrolls through the active window vertically by the number of rows you specify
public methodpublic methodVPageVertically scrolls through the active window one window at a time
public methodpublic methodVScrollVertically scrolls through the active sheet by percentage or by row number
public methodpublic methodWindowMaximizeChanges the active window from its normal size to full size
public methodpublic methodWindowMinimizeShrinks a window to an icon
public methodpublic methodWindowMoveMoves the active window so that its upper-left corner is at the specified horizontal and vertical positions
public methodpublic methodWindowRestoreChanges the active window from maximized or minimized size to its previous size
public methodpublic methodWindowSizeChanges the size of the active window by moving its lower-right corner so that the window has the width and height you specify
public methodpublic methodWorkbookActivateEquivalent to activating a worksheet by clicking on its tab
public methodpublic methodWorkbookCopyCopies a worksheet from the current workbook to another workbook or to a new position in the current workbook
public methodpublic methodWorkbookDeleteDeletes a sheet or group of sheets from the current workbook
public methodpublic methodWorkbookHideHides sheets in the active workbook
public methodpublic methodWorkbookInsertInserts one or more new sheets into the current workbook
public methodpublic methodWorkbookMoveMoves a worksheet from the current workbook to another workbook or to a new position in the current workbook
public methodpublic methodWorkbookNameRenames a sheet in a workbook
public methodpublic methodWorkbookNextActivates the next sheet in the active workbook
public methodpublic methodWorkbookPrevActivates the previous sheet in the active workbook
public methodpublic methodWorkbookProtectRenames a sheet in a workbook
public methodpublic methodWorkbookUnhideUnhides sheets in the active workbook
public methodpublic methodZoomEnlarges or reduces a document in the active window
public methodpublic methodZoomMaxThe current selection is enlarged or reduced to completely fill the active window
public methodpublic methodZoomNormalThe document is restored to normal 100% magnification

Customizing Macro Functions

public methodpublic methodFormulaEnters a formula in the active cell or in a reference
public methodpublic methodFormulaIntlEnters a US English formula in the active cell or in a reference
public methodpublic methodFormulaArrayEnters a formula as an array formula in the range specified or in the current selection
public methodpublic methodFormulaArrayIntlEnters a US English formula as an array formula in the range specified or in the current selection
public methodpublic methodAlertDisplays a dialog box and message and waits for you to choose a button
public methodpublic methodAppTitleChanges the title of the Microsoft Excel application workspace to the title you specify
public methodpublic methodBeepSounds a tone
public methodpublic methodDisableInputBlocks all input from the keyboard and mouse to Microsoft Excel
public methodpublic methodEchoControls screen updating while a macro is running

Information Macro Functions

public methodpublic methodActiveCellReturns the reference of the active cell in the selection as an external reference
public methodpublic methodCallerReturns information about the cell, range of cells, command on a menu, tool on a toolbar, or object that called the macro that is currently running
public methodpublic methodDirectorySets the current drive and directory or folder to the specified path and returns the name of the new directory or folder as text
public methodpublic methodDocumentsReturns the names of the specified open workbooks
public methodpublic methodFilesReturns the names of all files in the specified directory or folder
public methodpublic methodGetActiveWorkbookNameReturns the name of the active workbook
public methodpublic methodGetActiveWorksheetNameReturns the name of the active worksheet
public methodpublic methodGetCellReturns information about the cell, range of cells, command on a menu, tool on a toolbar, or object that called the macro that is currently running
public methodpublic methodGetCellIsArrayReturns whether a cell is part of an array
public methodpublic methodGetCellIsFormulaReturns whether a cell contains a formula
public methodpublic methodGetCellIsHiddenReturns whether a cell's formula is hidden
public methodpublic methodGetCellIsLockedReturns whether a cell is locked
public methodpublic methodGetDefReturns the name, as text, that is defined for a particular area, value, or formula in a workbook
public methodpublic methodGetDocumentReturns information about a sheet in a workbook
public methodpublic methodGetFormulaReturns the contents of a cell as they would appear in the formula bar
public methodpublic methodGetFormulaIntlReturns the contents of a cell as they would appear in the formula bar with US English settings
public methodpublic methodGetNameReturns the definition of a name as it appears in the Refers To box of the Define Name dialog box
public methodpublic methodGetNameIsLocalReturns TRUE if the name is defined for just the sheet
public methodpublic methodGetNoteReturns characters from a note
public methodpublic methodGetWorkbookReturns information about a workbook
public methodpublic methodWorkbookGetWorksheetNamesReturns a list of all the sheets in a workbook
public methodpublic methodGetWorkspaceReturns information about the workspace
public methodpublic methodNamesReturns the specified names defined in the specified workbook
public methodpublic methodSelectionReturns the reference or object identifier of the selection as an external reference
public methodpublic methodWindowsReturns the names of the specified open Microsoft Excel windows

Lookup & Reference Macro Functions

public methodpublic methodAbsRefReturns the absolute reference of the cells that are offset from a reference by a specified amount
public methodpublic methodDeRefReturns the value of the cells in a reference
public methodpublic methodEvaluateEvaluates a formula or expression that is in the form of text and returns the result
public methodpublic methodEvaluateIntlEvaluates a formula or expression that is in the form of English text and returns the result
public methodpublic methodFormulaConvertChanges the style and type of references in a formula between A1 and R1C1 and between relative and absolute
public methodpublic methodRefTextConverts a reference to an absolute reference in the form of text
public methodpublic methodRelRefReturns the reference of a cell or cells relative to the upper-left cell of rel_to_ref
public methodpublic methodTextRefConverts a reference to an absolute reference in the form of text

Requirements

Header: xlfuncs.h

See Also

CXlMacros Class | xlfuncs.h | CXlFuncs object | CXllApp::Excel | CXlOper::Excel