Showing posts with label Application Method. Show all posts
Showing posts with label Application Method. 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.

See ActivateMicrosoftApp Method

AddCustomList Method

Adds a custom list for custom autofill and/or custom sort.

See AddCustomList Method

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.

See ActivateMicrosoftApp Method

AddCustomList Method

Adds a custom list for custom autofill and/or custom sort.

See AddCustomList Method

Application Object

Application Event

A N P S W

Application Method

A C D E F G H I M N O Q R S U V W

Application Property

A C D E F G H I M N O Q R S U V W T U V W

Application Method TOC - W

Wait Method

Pauses a running macro until a specified time. Returns True if the specified time has arrived.

See Wait Method

Application Method TOC - V

Volatile Method

Marks a user-defined function as volatile. A volatile function must be recalculated whenever calculation occurs in any cells on the worksheet. A nonvolatile function is recalculated only when the input variables change. This method has no effect if it's not inside a user-defined function used to calculate a worksheet cell.

See Volatile Method

Application Method TOC - U

Undo Method

Cancels the last user-interface action.

See Undo Method

Union Method

Returns the union of two or more ranges.

See Union Method

Application Method TOC - S

SaveWorkspace Method

Saves the current workspace.

See SaveWorkspace Method

SendKeys Method

Sends keystrokes to the active application.

See SendKeys Method

SharePointVersion Method

Returns the version number of SharePoint Foundation instances running at site for the specified URL.

See SharePointVersion Method

Application Method TOC - R

RecordMacro Method

Records code if the macro recorder is on.

See RecordMacro Method

RegisterXLL Method

Loads an XLL code resource and automatically registers the functions and commands contained in the resource.

See RegisterXLL Method

Repeat Method

Repeats the last user-interface action.

See Repeat Method

Run Method

Runs a macro or calls a function. This can be used to run a macro written in Visual Basic or the Microsoft Excel macro language, or to run a function in a DLL or XLL.

See Run Method

Application Method TOC - Q

Quit Method

Quits Microsoft Excel.

See Quit Method

Application Method TOC - O

OnKey Method

Runs a specified procedure when a particular key or key combination is pressed.

See OnKey Method

OnRepeat Method

Sets the Repeat menu item and the name of the procedure that will run if you choose the Repeat command (Edit menu) after running the procedure that sets this property.

See OnRepeat Method

OnTime Method

Schedules a procedure to be run at a specified time in the future (either at a specific time of day or after a specific amount of time has passed).

See OnTime Method

OnUndo Method

Sets the text of the Undo and the name of the procedure that’s run if you choose the Undo command (Edit menu) after running the procedure that sets this property.

See OnUndo Method

Application Method TOC - N

NextLetter Method

You have requested Help for a Visual Basic keyword used only on the Macintosh. For information about this keyword, consult the language reference Help included with Microsoft Office Macintosh Edition.

See NextLetter Method

Application Method TOC - M

MacroOptions Method

Corresponds to options in the Macro Options dialog box. You can also use this method to display a user defined function (UDF) in a built-in or new category within the Insert Function dialog box.

See MacroOptions Method

MailLogoff Method

Closes a MAPI mail session established by Microsoft Excel.

See MailLogoff Method

MailLogon Method

Logs in to MAPI Mail or Microsoft Exchange and establishes a mail session. If Microsoft Mail isn't already running, you must use this method to establish a mail session before mail or document routing functions can be used.

See MailLogon Method

Application Method TOC - I

InchesToPoints Method

Converts a measurement from inches to points.

See InchesToPoints Method

InputBox Method

Displays a dialog box for user input. Returns the information entered in the dialog box.

See InputBox Method

Intersect Method

Returns a Range object that represents the rectangular intersection of two or more ranges.

See Intersect Method

Application Method TOC - H

Help Method

Displays a Help topic.

See Help Method

Application Method TOC - G

GetCustomListContents Method

Returns a custom list (an array of strings).

See GetCustomListContents Method

GetCustomListNum Method

Returns the custom list number for an array of strings. You can use this method to match both built-in lists and custom-defined lists.

See GetCustomListNum Method

GetOpenFilename Method

Displays the standard Open dialog box and gets a file name from the user without actually opening any files.

See GetOpenFilename Method

GetPhonetic Method

Returns the Japanese phonetic text of the specified text string. This method is available to you only if you have selected or installed Japanese language support for Microsoft Office.

See GetPhonetic Method

GetSaveAsFilename Method

Displays the standard Save As dialog box and gets a file name from the user without actually saving any files.

See GetSaveAsFilename Method

Goto Method

Selects any range or Visual Basic procedure in any workbook, and activates that workbook if it’s not already active.

See Goto Method

Application Method TOC - F

FindFile Method

Displays the Open dialog box.

See FindFile Method

Application Method TOC - E

Evaluate Method

Converts a Microsoft Excel name to an object or a value.

See Evaluate Method

ExecuteExcel4Macro Method

Runs a Microsoft Excel 4.0 macro function and then returns the result of the function. The return type depends on the function.

See ExecuteExcel4Macro Method

Application Method TOC - D

DDEExecute Method

Runs a command or performs some other action or actions in another application by way of the specified DDE channel.

See DDEExecute Method

DDEInitiate Method

Opens a DDE channel to an application.

See DDEInitiate Method

DDEPoke Method

Sends data to an application.

See DDEPoke Method

DDERequest Method

Requests information from the specified application. This method always returns an array.

See DDERequest Method

DDETerminate Method

Closes a channel to another application.

See DDETerminate Method

DeleteCustomList Method

Deletes a custom list.

See DeleteCustomList Method

DisplayXMLSourcePane Method

Opens the XML Source task pane and displays the XML map specified by the XmlMap argument.

See DisplayXMLSourcePane Method

DoubleClick Method

Equivalent to double-clicking the active cell.

See DoubleClick Method

Application Method TOC - C

Calculate Method

Calculates all open workbooks, a specific worksheet in a workbook, or a specified range of cells on a worksheet, as shown in the following table.

See Calculate Method

CalculateFull Method

Forces a full calculation of the data in all open workbooks.

See CalculateFull Method

CalculateFullRebuild Method

For all open workbooks, forces a full calculation of the data and rebuilds the dependencies.

See CalculateFullRebuild Method

CalculateUntilAsyncQueriesDone Method

Runs all pending queries to OLEDB and OLAP data sources.

See CalculateUntilAsyncQueriesDone Method

CentimetersToPoints Method

Converts a measurement from centimeters to points (one point equals 0.035 centimeters).

See CentimetersToPoints Method

CheckAbort Method

Stops recalculation in a Microsoft Excel application.

See CheckAbort Method

CheckSpelling Method

Checks the spelling of a single word.

See CheckSpelling Method

ConvertFormula Method

Converts cell references in a formula between the A1 and R1C1 reference styles, between relative and absolute references, or both. Variant.

See ConvertFormula Method

Application Intersect Method Method

Purpose

Returns a Range object that represents the rectangular intersection of two or more ranges.

Syntax

Intersect(Arg1, Arg2, Arg3, Arg4, Arg5, Arg6, Arg7, Arg8, Arg9, Arg10, Arg11, Arg12, Arg13, Arg14, Arg15, Arg16, Arg17, Arg18, Arg19, Arg20, Arg21, Arg22, Arg23, Arg24, Arg25, Arg26, Arg27, Arg28, Arg29, Arg30)

Required Parameters

Arg1

The intersecting ranges. At least two Range objects must be specified.

Arg2

The intersecting ranges. At least two Range objects must be specified.

Optional Parameters

Arg3

The intersecting ranges. At least two Range objects must be specified.

Arg4

The intersecting ranges. At least two Range objects must be specified.

Arg5

The intersecting ranges. At least two Range objects must be specified.

Arg6

The intersecting ranges. At least two Range objects must be specified.

Arg7

The intersecting ranges. At least two Range objects must be specified.

Arg8

The intersecting ranges. At least two Range objects must be specified.

Arg9

The intersecting ranges. At least two Range objects must be specified.

Arg10

The intersecting ranges. At least two Range objects must be specified.

Arg11

The intersecting ranges. At least two Range objects must be specified.

Arg12

The intersecting ranges. At least two Range objects must be specified.

Arg13

The intersecting ranges. At least two Range objects must be specified.

Arg14

The intersecting ranges. At least two Range objects must be specified.

Arg15

The intersecting ranges. At least two Range objects must be specified.

Arg16

The intersecting ranges. At least two Range objects must be specified.

Arg17

The intersecting ranges. At least two Range objects must be specified.

Arg18

The intersecting ranges. At least two Range objects must be specified.

Arg19

The intersecting ranges. At least two Range objects must be specified.

Arg20

The intersecting ranges. At least two Range objects must be specified.

Arg21

The intersecting ranges. At least two Range objects must be specified.

Arg22

The intersecting ranges. At least two Range objects must be specified.

Arg23

The intersecting ranges. At least two Range objects must be specified.

Arg24

The intersecting ranges. At least two Range objects must be specified.

Arg25

The intersecting ranges. At least two Range objects must be specified.

Arg26

The intersecting ranges. At least two Range objects must be specified.

Arg27

The intersecting ranges. At least two Range objects must be specified.

Arg28

The intersecting ranges. At least two Range objects must be specified.

Arg29

The intersecting ranges. At least two Range objects must be specified.

Arg30

The intersecting ranges. At least two Range objects must be specified.

Application InputBox Method Method

Purpose

Displays a dialog box for user input. Returns the information entered in the dialog box.

Syntax

InputBox(Prompt, Title, Default, Left, Top, HelpFile, HelpContextID, Type)

Required Parameters

Prompt

The message to be displayed in the dialog box. This can be a string, a number, a date, or a Boolean value (Microsoft Excel automatically coerces the value to a String before it is displayed).

Optional Parameters

Title

The title for the input box. If this argument is omitted, the default title is "Input."

Default

Specifies a value that will appear in the text box when the dialog box is initially displayed. If this argument is omitted, the text box is left empty. This value can be a Range object.

Left

Specifies an x position for the dialog box in relation to the upper-left corner of the screen, in points.

Top

Specifies a y position for the dialog box in relation to the upper-left corner of the screen, in points.

HelpFile

The name of the Help file for this input box. If the HelpFile and HelpContextID arguments are present, a Help button will appear in the dialog box.

HelpContextID

The context ID number of the Help topic in HelpFile.

Type

Specifies the return data type. If this argument is omitted, the dialog box returns text.