Exportar (0) Imprimir
Expandir todo
_Default Property
ActiveCell Property
ActiveChart Property
ActiveDialog Property
ActiveMenuBar Property
ActivePrinter Property
ActiveSheet Property
ActiveWindow Property
ActiveWorkbook Property
AddIns Property
AlertBeforeOverwriting Property
AltStartupPath Property
AnswerWizard Property
Application Property
ArbitraryXMLSupportAvailable Property
AskToUpdateLinks Property
Assistant Property
AutoCorrect Property
AutoFormatAsYouTypeReplaceHyperlinks Property
AutomationSecurity Property
AutoPercentEntry Property
AutoRecover Property
Build Property
CalculateBeforeSave Property
Calculation Property
CalculationInterruptKey Property
CalculationState Property
CalculationVersion Property
Caller Property
CanPlaySounds Property
CanRecordSounds Property
Caption Property
CellDragAndDrop Property
Cells Property
Charts Property
ClipboardFormats Property
ColorButtons Property
Columns Property
COMAddIns Property
CommandBars Property
CommandUnderlines Property
ConstrainNumeric Property
ControlCharacters Property
CopyObjectsWithCells Property
Creator Property
Cursor Property
CursorMovement Property
CustomListCount Property
CutCopyMode Property
DataEntryMode Property
DDEAppReturnCode Property
DecimalSeparator Property
DefaultFilePath Property
DefaultSaveFormat Property
DefaultSheetDirection Property
DefaultWebOptions Property
Dialogs Property
DialogSheets Property
DisplayAlerts Property
DisplayClipboardWindow Property
DisplayCommentIndicator Property
DisplayDocumentActionTaskPane Property
DisplayExcel4Menus Property
DisplayFormulaBar Property
DisplayFullScreen Property
DisplayFunctionToolTips Property
DisplayInfoWindow Property
DisplayInsertOptions Property
DisplayNoteIndicator Property
DisplayPasteOptions Property
DisplayRecentFiles Property
DisplayScrollBars Property
DisplayStatusBar Property
Dummy101 Property
EditDirectlyInCell Property
EnableAnimations Property
EnableAutoComplete Property
EnableCancelKey Property
EnableEvents Property
EnableSound Property
EnableTipWizard Property
ErrorCheckingOptions Property
Excel4IntlMacroSheets Property
Excel4MacroSheets Property
ExtendList Property
FeatureInstall Property
FileConverters Property
FileDialog Property
FileFind Property
FileSearch Property
FindFormat Property
FixedDecimal Property
FixedDecimalPlaces Property
GenerateGetPivotData Property
Height Property
Hinstance Property
Hwnd Property
IgnoreRemoteRequests Property
Interactive Property
International Property
Iteration Property
LanguageSettings Property
LargeButtons Property
Left Property
LibraryPath Property
MailSession Property
MailSystem Property
MapPaperSize Property
MathCoprocessorAvailable Property
MaxChange Property
MaxIterations Property
MemoryFree Property
MemoryTotal Property
MemoryUsed Property
MenuBars Property
Modules Property
MouseAvailable Property
MoveAfterReturn Property
MoveAfterReturnDirection Property
Name Property
Names Property
NetworkTemplatesPath Property
NewWorkbook Property
ODBCErrors Property
ODBCTimeout Property
OLEDBErrors Property
OnCalculate Property
OnData Property
OnDoubleClick Property
OnEntry Property
OnSheetActivate Property
OnSheetDeactivate Property
OnWindow Property
OperatingSystem Property
OrganizationName Property
Parent Property
Path Property
PathSeparator Property
PivotTableSelection Property
PreviousSelections Property
ProductCode Property
PromptForSummaryInfo Property
Range Property
Ready Property
RecentFiles Property
RecordRelative Property
ReferenceStyle Property
RegisteredFunctions Property
ReplaceFormat Property
RollZoom Property
Rows Property
RTD Property
ScreenUpdating Property
Selection Property
Sheets Property
SheetsInNewWorkbook Property
ShortcutMenus Property
ShowChartTipNames Property
ShowChartTipValues Property
ShowStartupDialog Property
ShowToolTips Property
ShowWindowsInTaskbar Property
SmartTagRecognizers Property
Speech Property
SpellingOptions Property
StandardFont Property
StandardFontSize Property
StartupPath Property
StatusBar Property
TemplatesPath Property
ThisCell Property
ThisWorkbook Property
ThousandsSeparator Property
Toolbars Property
Top Property
TransitionMenuKey Property
TransitionMenuKeyAction Property
TransitionNavigKeys Property
UILanguage Property
UsableHeight Property
UsableWidth Property
UsedObjects Property
UserControl Property
UserLibraryPath Property
UserName Property
UseSystemSeparators Property
Value Property
VBE Property
Version Property
Visible Property
Watches Property
Width Property
Windows Property
WindowsForPens Property
WindowState Property
Workbooks Property
WorksheetFunction Property
Worksheets Property
Expandir Minimizar

_Application.Workbooks Property

Returns a Workbooks collection that represents all the open workbooks.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)

Dim _Application1 As _Application

Dim returnValue As Workbooks
returnValue = _Application1.Workbooks

Workbooks Workbooks {get;}
public Workbooks get_Workbooks();
function get Workbooks() : Workbooks;

The collection returned by the Workbooks property doesn’t include open add-ins, which are a special kind of hidden workbook. You can, however, return a single open add-in if you know the file name. For example, Workbooks("Oscar.xla") will return the open add-in named "Oscar.xla" as a Workbook object.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

© 2014 Microsoft