Action Method
Showing posts with label Application. Show all posts
Showing posts with label Application. Show all posts
Application Method TOC - A
ActivateMicrosoftApp Method
Activates a Microsoft application. If the application is already running, this method activates the running application. If the application isn't running, this method starts a new instance of the application.
AddCustomList Method
Adds a custom list for custom autofill and/or custom sort.
ActivateMicrosoftApp Method
Activates a Microsoft application. If the application is already running, this method activates the running application. If the application isn't running, this method starts a new instance of the application.
AddCustomList Method
Adds a custom list for custom autofill and/or custom sort.
Application Property TOC - W
Application WarnOnFunctionNameConflict Property
The WarnOnFunctionNameConflict property, when set to True, raises an alert if a developer tries to create a new function using an existing function name. Read/write Boolean.
Application Watches Property
Returns a Watches object representing a range which is tracked when the worksheet is recalculated.
Application Width Property
Returns or sets a Double value that represents the distance, in points, from the left edge of the application window to its right edge.
Application Windows Property
Returns a Windows collection that represents all the windows in all the workbooks. Read-only Windows object.
Application WindowsForPens Property
True if the computer is running under Microsoft Windows for Pen Computing. Read-only Boolean.
Application WindowState Property
Returns or sets the state of the window. Read/write XlWindowState.
Application Workbooks Property
Returns a Workbooks collection that represents all the open workbooks. Read-only.
Application WorksheetFunction Property
Returns the WorksheetFunction object. Read-only.
Application Worksheets Property
For an Application object, returns a Sheets collection that represents all the worksheets in the active workbook. For a Workbook object, returns a Sheets collection that represents all the worksheets in the specified workbook. Read-only Sheets object.
Application Property TOC - V
Application Value Property
Returns a String value that represents the name of the application.
Application VBE Property
Returns a VBE object that represents the Visual Basic Editor. Read-only.
Application Version Property
Returns a String value that represents the Microsoft Excel version number.
Application Visible Property
Returns or sets a Boolean value that determines whether the object is visible. Read/write.
Application Property TOC - U
Application UsableHeight Property
Returns the maximum height of the space that a window can occupy in the application window area, in points. Read-only Double.
Application UsableWidth Property
Returns the maximum width of the space that a window can occupy in the application window area, in points. Read-only Double.
Application UseClusterConnector Property
Returns or sets whether Excel allows user-defined functions in XLL add-ins to be run on a compute cluster. Read/write
Application UsedObjects Property
Returns a UsedObjects object representing objects allocated in a workbook. Read-only
Application UserControl Property
True if the application is visible or if it was created or started by the user. False if you created or started the application programmatically by using the CreateObject or GetObject functions, and the application is hidden. Read/write Boolean.
Application UserLibraryPath Property
Returns the path to the location on the user’s computer where the COM add-ins are installed. Read-only String.
Application UserName Property
Returns or sets the name of the current user. Read/write String.
Application UseSystemSeparators Property
True (default) if the system separators of Microsoft Excel are enabled. Read/write Boolean.
Application Property TOC - T
Application TemplatesPath Property
Returns the local path where templates are stored. Read-only String.
Application ThisCell Property
Returns the cell in which the user-defined function is being called from as a Range object.
Application ThisWorkbook Property
Returns a Workbook object that represents the workbook where the current macro code is running. Read-only.
Application ThousandsSeparator Property
Sets or returns the character used for the thousands separator as a String. Read/write.
Application Top Property
Returns or sets a Double value that represents the distance, in points, from the top edge of the screen to the top edge of the main Microsoft Excel window.
Application TransitionMenuKey Property
Returns or sets the Microsoft Excel menu or help key, which is usually "/". Read/write String.
Application TransitionMenuKeyAction Property
Returns or sets the action taken when the Microsoft Excel menu key is pressed. Can be either xlExcelMenus or xlLotusHelp. Read/write Long.
Application TransitionNavigKeys Property
True if transition navigation keys are active. Read/write Boolean.
Application Property TOC - S
Application ScreenUpdating Property
True if screen updating is turned on. Read/write Boolean.
Application Selection Property
Returns the selected object in the active window for an Application object.
Application Sheets Property
Returns a Sheets collection that represents all the sheets in the active workbook. Read-only Sheets object.
Application SheetsInNewWorkbook Property
Returns or sets the number of sheets that Microsoft Excel automatically inserts into new workbooks. Read/write Long.
Application ShowChartTipNames Property
True if charts show chart tip names. The default value is True. Read/write Boolean.
Application ShowChartTipValues Property
True if charts show chart tip values. The default value is True. Read/write Boolean.
Application ShowDevTools Property
Returns or sets a Boolean that represents whether the Developer tab is displayed in the ribbon. Read/write Boolean.
Application ShowMenuFloaties Property
Returns or sets a Boolean that represents whether to display Mini toolbars when the user right-clicks in the workbook window. False if Mini toolbars are displayed. Read/write Boolean.
Application ShowQuickAnalysis Property
Controls whether the Quick Analysis contextual user interface is displayed on selection. TRUE means the Quick Analysis button will show. Corresponds to the Show Quick Analysis options on selection checkbox located in the File menu, Options, Excel Options, and then General tab. Read/Write. Boolean.
Application ShowSelectionFloaties Property
Returns or sets a Boolean that represents whether Mini toolbars displays when a user selects text. False if Mini toolbars are displayed. Read/write Boolean.
Application ShowStartupDialog Property
Returns True (default is False) when the New Workbook task pane appears for a Microsoft Excel application. Read/write Boolean.
Application ShowToolTips Property
True if ToolTips are turned on. Read/write Boolean.
Application SmartArtColors Property
Returns the set of color styles that are currently loaded in the application. Read-only
Application SmartArtLayouts Property
Returns the set of SmartArt layouts that are currently loaded in the application. Read-only
Application SmartArtQuickStyles Property
Returns the set of SmartArt quick styles which are currently loaded in the application. Read-only
Application SpellingOptions Property
Returns a SpellingOptions object that represents the spelling options of the application.
Application StandardFont Property
Returns or sets the name of the standard font. Read/write String.
Application StandardFontSize Property
Returns or sets the standard font size, in points. Read/write Long.
Application StartupPath Property
Returns the complete path of the startup folder, excluding the final separator. Read-only String.
Application StatusBar Property
Returns or sets the text in the status bar. Read/write String.
Application Property TOC - R
Application Range Property
Returns a Range object that represents a cell or a range of cells.
Application Ready Property
Returns True when the Microsoft Excel application is ready; False when the Excel application is not ready. Read-only Boolean.
Application RecentFiles Property
Returns a RecentFiles collection that represents the list of recently used files.
Application RecordRelative Property
True if macros are recorded using relative references; False if recording is absolute. Read-only Boolean.
Application ReferenceStyle Property
Returns or sets how Microsoft Excel displays cell references and row and column headings in either A1 or R1C1 reference style. Read/write XlReferenceStyle.
Application RegisteredFunctions Property
Returns information about functions in either dynamic-link libraries (DLLs) or code resources that were registered with the REGISTER or REGISTER.ID macro functions. Read-only Variant.
Application ReplaceFormat Property
Sets the replacement criteria to use in replacing cell formats. The replacement criteria is then used in a subsequent call to the Replace method of the Range object.
Application RollZoom Property
True if the IntelliMouse zooms instead of scrolling. Read/write Boolean.
Application Rows Property
Returns a Range object that represents all the rows on the active worksheet. If the active document isn’t a worksheet, the Rows property fails. Read-only Range object.
Application Property TOC - Q
Application QuickAnalysis Property
Returns a QuickAnalysis object that represents the Quick Analysis options of the application.
Application Property TOC - P
Application Parent Property
Returns the parent object for the specified object. Read-only.
Application Path Property
Returns a String value that represents the complete path to the application, excluding the final separator and name of the application.
Application PathSeparator Property
Returns the path separator character ("\"). Read-only String.
Application PivotTableSelection Property
True if PivotTable reports use structured selection. Read/write Boolean.
Application PreviousSelections Property
Returns an array of the last four ranges or names selected. Each element in the array is a Range object. Read-only Variant.
Application PrintCommunication Property
Specifies whether communication with the printer is turned on. Boolean Read/write
Application ProductCode Property
Returns the globally unique identifier (GUID) for Microsoft Excel. Read-only String.
Application PromptForSummaryInfo Property
True if Microsoft Excel asks for summary information when files are first saved. Read/write Boolean.
Application ProtectedViewWindows Property
Returns a ProtectedViewWindows collection that represents all the Protected View windows that are open in the application. Read-only
Application Property TOC - O
Application ODBCErrors Property
Returns an ODBCErrors collection that contains all the ODBC errors generated by the most recent query table or PivotTable report operation. Read-only.
Application ODBCTimeout Property
Returns or sets the ODBC query time limit, in seconds. The default value is 45 seconds. Read/write Long.
Application OLEDBErrors Property
Returns the OLEDBErrors collection, which represents the error information returned by the most recent OLE DB query. Read-only.
Application OnWindow Property
Returns or sets the name of the procedure that’s run whenever you activate a window. Read/write String.
Application OperatingSystem Property
Returns the name and version number of the current operating system — for example, "Windows (32-bit) 4.00" or "Macintosh 7.00". Read-only String.
Application OrganizationName Property
Returns the registered organization name. Read-only String.
Application Property TOC - N
Application Name Property
Returns a String value that represents the name of the object.
Application Names Property
Returns a Names collection that represents all the names in the active workbook. Read-only Names object.
Application NetworkTemplatesPath Property
Returns the network path where templates are stored. If the network path doesn’t exist, this property returns an empty string. Read-only String.
Application Property TOC - M
Application MailSession Property
Returns the MAPI mail session number as a hexadecimal string (if there's an active session), or returns null if there's no session. Read-only Variant.
Application MailSystem Property
Returns the mail system that's installed on the host machine. Read-only XlMailSystem.
Application MapPaperSize Property
True if documents formatted for the standard paper size of another country/region (for example, A4) are automatically adjusted so that they're printed correctly on the standard paper size (for example, Letter) of your country/region. Read/write Boolean.
Application MathCoprocessorAvailable Property
True if a math coprocessor is available. Read-only Boolean.
Application MaxChange Property
Returns or sets the maximum amount of change between each iteration as Microsoft Excel resolves circular references. Read/write Double.
Application MaxIterations Property
Returns or sets the maximum number of iterations that Microsoft Excel can use to resolve a circular reference. Read/write Long.
Application MeasurementUnit Property
Specifies the measurement unit used in the application. Read/write xlMeasurementUnit.
Application MouseAvailable Property
True if a mouse is available. Read-only Boolean.
Application MoveAfterReturn Property
True if the active cell will be moved as soon as the ENTER (RETURN) key is pressed. Read/write Boolean.
Application MoveAfterReturnDirection Property
Returns or sets the direction in which the active cell is moved when the user presses ENTER. Read/write XlDirection.
Application MultiThreadedCalculation Property
Returns a MultiThreadedCalculation object that controls the multi-threaded recalculation settings. Read-only.
Application Property TOC - L
Application LanguageSettings Property
Returns the LanguageSettings object, which contains information about the language settings in Microsoft Excel. Read-only.
Application LargeOperationCellThousandCount Property
Returns or sets the maximum number of cells needed in an operation beyond which an alert is triggered. Read/write Long.
Application Left Property
Returns or sets a Double value that represents the distance, in points, from the left edge of the screen to the left edge of the main Microsoft Excel window.
Application LibraryPath Property
Returns the path to the Library folder, but without the final separator. Read-only String.
Application Property TOC - I
Application IgnoreRemoteRequests Property
True if remote DDE requests are ignored. Read/write Boolean.
Application Interactive Property
True if Microsoft Excel is in interactive mode; this property is usually True. If you set the this property to False, Microsoft Excel will block all input from the keyboard and mouse (except input to dialog boxes that are displayed by your code). Read/write Boolean.
Application International Property
Returns information about the current country/region and international settings. Read-only Variant.
Application IsSandboxed Property
Returns True if the specified workbook is open in a Protected View window. Read-only
Application Iteration Property
True if Microsoft Excel will use iteration to resolve circular references. Read/write Boolean.
Application Property TOC - H
Application Height Property
Returns or sets a Double value that represents tThe height, in points, of the main application window.
Application HighQualityModeForGraphics Property
Returns or sets whether Excel uses high quality mode to print graphics. Read/write
Application Hinstance Property
Returns a handle to the instance of Microsoft Excel 2013 represented by the Application object. Read-only Long.
Application HinstancePtr Property
Returns a handle to the instance of Microsoft Excel 2013 represented by the specified Application object. Read-only Variant.
Application Hwnd Property
Returns a Long indicating the top-level window handle of the Microsoft Excel window. Read-only.
Application Property TOC - G
Application GenerateGetPivotData Property
Returns True when Microsoft Excel can get PivotTable report data. Read/write Boolean.
Application GenerateTableRefs Property
The GenerateTableRefs property determines whether the traditional notation method or the new structured referencing notation method is used for referencing tables in formulas. Read/write.
Application Property TOC - F
Application FeatureInstall Property
Returns or sets a value (constant) that specifies how Microsoft Excel handles calls to methods and properties that require features that aren’t yet installed. Can be one of the MsoFeatureInstall constants listed in the following table. Read/write MsoFeatureInstall.
Application FileConverters Property
Returns information about installed file converters. Returns null if there are no converters installed. Read-only Variant.
Application FileDialog Property
Returns a FileDialog object representing an instance of the file dialog.
Application FileExportConverters Property
Returns a FileExportConverters collection that represents all the file converters for saving files available to Microsoft Excel. Read-only.
Application FileValidation Property
Returns or sets how Excel will validate files before opening them. Read/write
Application FileValidationPivot Property
Returns or sets how Excel will validate the contents of the data caches for PivotTable reports. Read/write
Application FindFormat Property
Sets or returns the search criteria for the type of cell formats to find.
Application FixedDecimal Property
All data entered after this property is set to True will be formatted with the number of fixed decimal places set by the FixedDecimalPlaces property. Read/write Boolean.
Application FixedDecimalPlaces Property
Returns or sets the number of fixed decimal places used when the FixedDecimal property is set to True. Read/write Long.
Application FlashFill Property
TRUE indicates that the Excel Flash Fill feature has been enabled and active. Boolean Read/Write
Application FlashFillMode Property
True if the Flash Fill feature is enabled. Boolean Read/Write
Application FormulaBarHeight Property
Allows the user to specify the height of the formula bar in lines. Read/write Long.
Application Property TOC - E
Application EditDirectlyInCell Property
True if Microsoft Excel allows editing in cells. Read/write Boolean.
Application EnableAutoComplete Property
True if the AutoComplete feature is enabled. Read/write Boolean.
Application EnableCancelKey Property
Controls how Microsoft Excel handles CTRL+BREAK (or ESC or COMMAND+PERIOD) user interruptions to the running procedure. Read/write XlEnableCancelKey.
Application EnableEvents Property
True if events are enabled for the specified object. Read/write Boolean.
Application EnableLargeOperationAlert Property
Sets or returns a Boolean that represents whether to display an alert message when a user attempts to perform an operation that affects a larger number of cells than is specified in the Office center UI. Read/write Boolean.
Application EnableLivePreview Property
Sets or returns a Boolean that represents whether to show or hide gallery previews that appear when using galleries that support previewing. Setting this property to True shows a preview of your workbook before applying the command. Read/write Boolean.
Application EnableMacroAnimations Property
Controls whether macro animations are enabled. True if user interface animations or chart animations are enabled. Is set to False (no animation) by default. If it is set to True during the running of a macro, it will enable animation and then will reset to False after the macro runs. Read/write Boolean.
Application EnableSound Property
True if sound is enabled for Microsoft Office. Read/write Boolean.
Application ErrorCheckingOptions Property
Returns an ErrorCheckingOptions object, which represents the error checking options for an application.
Application Excel4IntlMacroSheets Property
Returns a Sheets collection that represents all the Microsoft Excel 4.0 international macro sheets in the specified workbook. Read-only.
Application Excel4MacroSheets Property
Returns a Sheets collection that represents all the Microsoft Excel 4.0 macro sheets in the specified workbook. Read-only.
Application ExtendList Property
True if Microsoft Excel automatically extends formatting and formulas to new data that is added to a list. Read/write Boolean.
Subscribe to:
Posts (Atom)