Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Office and SharePoint development
Office client development
Office 2010
Excel 2010
Excel 2010 Primary Interop Assembly Reference
Class Library
Microsoft.Office.Interop.Excel Namespace
_Application Interface
_Application Methods
_Evaluate Method
_FindFile Method
_Run2 Method
_Wait Method
_WSFunction Method
ActivateMicrosoftApp Method
AddChartAutoFormat Method
AddCustomList Method
Calculate Method
CalculateFull Method
CalculateFullRebuild Method
CalculateUntilAsyncQueriesDone Method
CentimetersToPoints Method
CheckAbort Method
CheckSpelling Method
ConvertFormula Method
DDEExecute Method
DDEInitiate Method
DDEPoke Method
DDERequest Method
DDETerminate Method
DeleteChartAutoFormat Method
DeleteCustomList Method
DisplayXMLSourcePane Method
DoubleClick Method
Dummy1 Method
Dummy10 Method
Dummy11 Method
Dummy12 Method
Dummy13 Method
Dummy14 Method
Dummy2 Method
Dummy20 Method
Dummy3 Method
Dummy4 Method
Dummy5 Method
Dummy6 Method
Dummy7 Method
Dummy8 Method
Dummy9 Method
Evaluate Method
ExecuteExcel4Macro Method
FindFile Method
GetCustomListContents Method
GetCustomListNum Method
GetOpenFilename Method
GetPhonetic Method
GetSaveAsFilename Method
Goto Method
Help Method
InchesToPoints Method
InputBox Method
Intersect Method
MacroOptions Method
MacroOptions2 Method
MailLogoff Method
MailLogon Method
NextLetter Method
OnKey Method
OnRepeat Method
OnTime Method
OnUndo Method
Quit Method
RecordMacro Method
RegisterXLL Method
Repeat Method
ResetTipWizard Method
Run Method
Save Method
SaveWorkspace Method
SendKeys Method
SetDefaultChart Method
SharePointVersion Method
Support Method
Undo Method
Union Method
Volatile Method
Wait Method
Expand Minimize
This topic has not yet been rated - Rate this topic

_Application.RecordMacro Method

Office 2010

Records code if the macro recorder is on.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
C#
VB
Copy 
void RecordMacro(
	Object BasicCode,
	Object XlmCode
)

Parameters

BasicCode
Type: System.Object
Optional Object. A string that specifies the Visual Basic code that will be recorded if the macro recorder is recording into a Visual Basic module. The string will be recorded on one line. If the string contains a carriage return (ASCII character 10, or Chr$(10) in code), it will be recorded on more than one line.
XlmCode
Type: System.Object
Optional Object. This argument is ignored.

The RecordMacro method cannot record into the active module (the module in which the RecordMacro method exists).

To prevent recording (for example, if the user cancels your dialog box), call this function with two empty strings.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.