Book description
Why program Excel? For solving complex calculations and presenting results, Excel is amazingly complete with every imaginable feature already in place. But programming Excel isn't about adding new features as much as it's about combining existing features to solve particular problems. With a few modifications, you can transform Excel into a task-specific piece of software that will quickly and precisely serve your needs. In other words, Excel is an ideal platform for probably millions of small spreadsheet-based software solutions.
The best part is, you can program Excel with no additional tools. A variant of the Visual Basic programming language, VB for Applications (VBA) is built into Excel to facilitate its use as a platform. With VBA, you can create macros and templates, manipulate user interface features such as menus and toolbars, and work with custom user forms or dialog boxes. VBA is relatively easy to use, but if you've never programmed before, Programming Excel with VBA and .NET is a great way to learn a lot very quickly. If you're an experienced Excel user or a Visual Basic programmer, you'll pick up a lot of valuable new tricks. Developers looking forward to .NET development will also find discussion of how the Excel object model works with .NET tools, including Visual Studio Tools for Office (VSTO).
This book teaches you how to use Excel VBA by explaining concepts clearly and concisely in plain English, and provides plenty of downloadable samples so you can learn by doing. You'll be exposed to a wide range of tasks most commonly performed with Excel, arranged into chapters according to subject, with those subjects corresponding to one or more Excel objects. With both the samples and important reference information for each object included right in the chapters, instead of tucked away in separate sections, Programming Excel with VBA and .NET covers the entire Excel object library. For those just starting out, it also lays down the basic rules common to all programming languages.
With this single-source reference and how-to guide, you'll learn to use the complete range of Excel programming tasks to solve problems, no matter what you're experience level.
Publisher resources
Table of contents
- Programming Excel with VBA and .NET
- A Note Regarding Supplemental Files
- Preface
-
I. Learning VBA
- 1. Becoming an Excel Programmer
- 2. Knowing the Basics
- 3. Tasks in Visual Basic
- 4. Using Excel Objects
- 5. Creating Your Own Objects
- 6. Writing Code for Use by Others
-
II. Excel Objects
-
7. Controlling Excel
- 7.1. Perform Tasks
- 7.2. Control Excel Options
- 7.3. Get References
-
7.4. Application Members
- [Application.]ActivateMicrosoftApp(XlMSApplication)
- [Application.]ActivePrinter [= setting]
- Application.AddChartAutoFormat(Chart, Name, [Description])
- Application.AddCustomList(ListArray, [ByRow])
- Application.AlertBeforeOverwriting [= setting]
- Application.AltStartupPath
- Application.ArbitraryXMLSupportAvailable
- Application.AskToUpdateLinks [= setting]
- Application.Assistant
- Application.AutoCorrect
- Application.AutoFormatAsYouTypeReplaceHyperlinks [= setting]
- Application.AutomationSecurity [=MsoAutomationSecurity]
- Application.AutoPercentEntry [= setting]
- Application.AutoRecover
- Application.Build
- [Application.]Calculate( )
- Application.CalculateBeforeSave [= setting]
- Application.CalculateFull( )
- Application.CalculateFullRebuild( )
- Application.Calculation [= XlCalculation]
- Application.CalculationInterruptKey [= XlCalculationInterruptKey]
- Application.CalculationState
- Application.CalculationVersion
- Application.Caller
- Application.Caption [= setting]
- Application.CellDragAndDrop [= setting]
- [Application.]Cells[(row, column)]
- Application.CentimetersToPoints(Centimeters)
- [Application.]Charts([index])
- Application.CheckAbort([KeepAbort])
- Application.CheckSpelling(Word, [CustomDictionary], [IgnoreUppercase])
- Application.ClipboardFormats
- [Application].Columns([index])
- Application.COMAddIns([index])
- Application.CommandBars([index])
- Application.CommandUnderlines [= xlCommandUnderlines]
- Application.ConstrainNumeric [= setting]
- Application.ControlCharacters [= setting]
- Application.ConvertFormula(Formula, FromReferenceStyle, [ToReferenceStyle], [ToAbsolute], [RelativeTo])
- Application.CopyObjectsWithCells [= setting]
- Application.Cursor [= XlMousePointer]
- Application.CursorMovement [= setting]
- Application.CustomListCount
- Application.CutCopyMode [= setting]
- Application.DataEntryMode [= setting]
- Application.DecimalSeparator [= setting]
- Application.DefaultFilePath [= setting]
- Application.DefaultSaveFormat [= XlFileFormat]
- Application.DefaultSheetDirection [= setting]
- Application.DefaultWebOptions
- Application.DeleteChartAutoFormat(Name)
- [Application.]DeleteCustomList(ListNum)
- Application.Dialogs(XlBuiltInDialog)
- Application.DisplayAlerts [= setting]
- Application.DisplayClipboardWindow [= setting]
- Application.DisplayCommentIndicator [=XlCommentDisplayMode]
- Application.DisplayDocumentActionTaskPane [= setting]
- Application.DisplayExcel4Menus [= setting]
- Application.DisplayFormulaBar [= setting]
- Application.DisplayFullScreen [= setting]
- Application.DisplayFunctionToolTips [= setting]
- Application.DisplayInsertOptions [= setting]
- Application.DisplayNoteIndicator [= setting]
- Application.DisplayPasteOptions [= setting]
- Application.DisplayRecentFiles [= setting]
- Application.DisplayScrollBars [= setting]
- Application.DisplayStatusBar [= setting]
- Application.DisplayXMLSourcePane ([XmlMap])
- Application.DoubleClick( )
- Application.EditDirectlyInCell [= setting]
- Application.EnableAnimations [= setting]
- [Application.]EnableAutoComplete [= setting]
- Application.EnableCancelKey [= XlEnableCancelKey]
- Application.EnableEvents [= setting]
- Application.EnableSound [= setting]
- Application.ErrorCheckingOptions
- [Application.]Evaluate(Name)
- Application.ExtendList [= setting]
- Application.FeatureInstall [= MsoFeatureInstall]
- Application.FileConverters[(Index1, Index2)]
- Application.FileDialog (MsoFileDialogType)
- Application.FileFind
- Application.FileSearch
- Application.FindFile( )
- Application.FindFormat
- Application.FixedDecimal [= setting]
- Application.FixedDecimalPlaces [= setting]
- Application.GenerateGetPivotData [= setting]
- Application.GetCustomListContents
- Application.GetCustomListNum(ListArray)
- Application.GetOpenFilename([FileFilter], [FilterIndex], [Title], [ButtonText], [MultiSelect])
- Application.GetPhonetic([Text])
- Application.GetSaveAsFilename([InitialFilename], [FileFilter], [FilterIndex], [Title], [ButtonText])
- Application.Goto([Reference], [Scroll])
- Application.Height
- Application.Help([HelpFile], [HelpContextID])
- Application.Hinstance
- Application.Hwnd
- Application.InchesToPoints(Inches)
- [Application.]InputBox(Prompt, [Title], [Default], [Left], [Top], [HelpFile], [HelpContextID], [Type])
- Application.Interactive [= setting]
- Application.International(XlApplicationInternational)
- [Application.]Intersect(Arg1, Arg2, [Argn], ...)
- Application.Iteration [= setting]
- Application.LanguageSettings
- Application.LargeButtons [= setting]
- Application.Left [= setting]
- Application.LibraryPath
- Application.MacroOptions([Macro], [Description], [HasMenu], [MenuText], [HasShortcutKey], [ShortcutKey], [Category], [StatusBar], [HelpContextId], [HelpFile])
- Application.MailLogoff( )
- Application.MailLogon([Name], [Password], [DownloadNewMail])
- Application.MailSession
- Application.MailSystem
- Application.MapPaperSize [= setting]
- Application.MaxChange [= setting]
- Application.MaxIterations [= setting]
- Application.MoveAfterReturn [= setting]
- Application.MoveAfterReturnDirection [=XlDirection]
- Application.Names([index])
- Application.NetworkTemplatesPath
- Application.NewWorkbook
- Application.NextLetter( )
- Application.ODBCErrors
- Application.ODBCTimeout [= setting]
- Application.OLEDBErrors
- Application.OnKey(Key, [Procedure])
- Application.OnRepeat(Text, Procedure)
- Application.OnTime(EarliestTime, Procedure, [LatestTime], [Schedule])
- Application.OnUndo(Text, Procedure)
- Application.OnWindow [= setting]
- Application.OperatingSystem
- Application.OrganizationName
- Application.Path
- Application.PathSeparator
- Application.PivotTableSelection [= setting]
- Application.PreviousSelections([index])
- Application.ProductCode
- Application.PromptForSummaryInfo [= setting]
- Application.Quit( )
- [Application.]Range([cell1],[cell2])
- Application.Ready
- Application.RecentFiles([index])
- Application.RecordMacro([BasicCode], [XlmCode])
- Application.RecordRelative [= setting]
- Application.ReferenceStyle [=XlReferenceStyle]
- Application.RegisteredFunctions
- Application.RegisterXLL(Filename)
- Application.Repeat( )
- Application.ReplaceFormat [= setting]
- Application.RollZoom [= setting]
- [Application.]Rows([index])
- Application.RTD
- Application.Run([Macro], [Args])
- Application.SaveWorkspace([Filename])
- Application.ScreenUpdating [= setting]
- Application.Selection
- Application.SendKeys(Keys, [Wait])
- Application.SetDefaultChart([FormatName], [Gallery])
- [Application.]Sheets([index])
- Application.SheetsInNewWorkbook [= setting]
- Application.ShowChartTipNames [= setting]
- Application.ShowChartTipValues [= setting]
- Application.ShowStartupDialog [= setting]
- Application.ShowToolTips [= setting]
- Application.ShowWindowsInTaskbar [= setting]
- Application.SmartTagRecognizers
- Application.Speech
- Application.SpellingOptions
- Application.StandardFont [= setting]
- Application.StandardFontSize [= setting]
- Application.StartupPath
- Application.StatusBar [= setting]
- Application.TemplatesPath
- Application.ThisCell
- Application.ThisWorkbook
- Application.ThousandsSeparator [= setting]
- Application.Top [= setting]
- Application.Undo( )
- [Application.]Union(Arg1, Arg2, [Argn])
- Application.UsableHeight
- Application.UsableWidth
- Application.UsedObjects
- Application.UserControl
- Application.UserLibraryPath
- Application.UserName [= setting]
- Application.UseSystemSeparators [= setting]
- Application.VBE
- Application.Version
- Application.Visible [= setting]
- Application.Volatile([Volatile])
- Application.Wait(Time)
- Application.Watches([index])
- Application.Width [= setting]
- Application.Windows([index])
- Application.WindowsForPens
- Application.WindowState [= XlWindowState]
- [Application.]Workbooks([index])
- [Application.]WorksheetFunction
- [Application.]Worksheets([index])
- 7.5. AutoCorrect Members
- 7.6. AutoRecover Members
- 7.7. ErrorChecking Members
- 7.8. SpellingOptions Members
-
7.9. Window and Windows Members
- window.Activate( )
- window.ActivateNext( )
- window.ActivatePrevious( )
- windows.Arrange([ArrangeStyle], [ActiveWorkbook], [SyncHorizontal], [SyncVertical])
- windows.BreakSideBySide( )
- window.Close([SaveChanges], [Filename], [RouteWorkbook])
- windows.CompareSideBySideWith(WindowName)
- window.DisplayFormulas [= setting]
- window.DisplayGridlines [= setting]
- window.DisplayHeadings [= setting]
- window.DisplayHorizontalScrollBar [= setting]
- window.DisplayOutline [= setting]
- window.DisplayRightToLeft [= setting]
- window.DisplayVerticalScrollBar [= setting]
- window.DisplayWorkbookTabs [= setting]
- window.DisplayZeros [= setting]
- window.EnableResize [= setting]
- window.FreezePanes [= setting]
- window.GridlineColor [= setting]
- window.GridlineColorIndex [=xlColorIndexAutomatic]
- window.LargeScroll([Down], [Up], [ToRight], [ToLeft])
- window.Panes
- window.PointsToScreenPixelsX(Points)
- window.PointsToScreenPixelsY(Points)
- window.RangeFromPoint(x, y)
- window.RangeSelection
- windows.ResetPositionsSideBySide( )
- window.ScrollColumn [= setting]
- window.ScrollIntoView(Left, Top, Width, Height, [Start])
- window.ScrollRow [= setting]
- window.ScrollWorkbookTabs([Sheets], [Position])
- window.SelectedSheets
- window.Selection
- window.SmallScroll([Down], [Up], [ToRight], [ToLeft])
- window.Split [= setting]
- window.SplitColumn [= setting]
- window.SplitHorizontal [= setting]
- window.SplitRow [= setting]
- window.SplitVertical [= setting]
- windows.SyncScrollingSideBySide [= setting]
- window.TabRatio [= setting]
- window.View [= XlWindowView]
- window.VisibleRange
- window.WindowNumber [= setting]
- window.WindowState [= XlWindowState]
- window.Zoom [= setting]
- 7.10. Pane and Panes Members
-
8. Opening, Saving, and Sharing Workbooks
- 8.1. Add, Open, Save, and Close
- 8.2. Share Workbooks
- 8.3. Program with Shared Workbooks
- 8.4. Program with Shared Workspaces
- 8.5. Respond to Actions
-
8.6. Workbook and Workbooks Members
- workbook.AcceptAllChanges([When], [Who], [Where])
- workbook.AcceptLabelsInFormulas [= setting]
- workbook.Activate( )
- workbook.ActiveChart
- workbook.ActiveSheet
- workbooks.Add([Template])
- workbook.AddToFavorites
- workbook.Author [= setting]
- workbook.AutoUpdateFrequency [= setting]
- workbook.AutoUpdateSaveChanges [= setting]
- workbook.BreakLink(Name, Type)
- workbook.BuiltinDocumentProperties
- workbook.CalculationVersion
- workbook.CanCheckIn
- workbooks.CanCheckOut(Filename)
- workbook.ChangeFileAccess(Mode, [WritePassword], [Notify])
- workbook.ChangeHistoryDuration [= setting]
- workbook.ChangeLink(Name, NewName, [Type])
- workbook.Charts
- workbook.CheckIn([SaveChanges], [Comments], [MakePublic])
- workbooks.CheckOut(Filename)
- workbook.Close([SaveChanges], [Filename], [RouteWorkbook])
- workbook.CodeName
- workbook.Colors [= setting]
- workbook.CommandBars
- workbook.Comments [= setting]
- workbook.ConflictResolution [= setting]
- workbook.Container
- workbook.CreateBackup [= setting]
- workbook.CustomDocumentProperties
- workbook.CustomViews
- workbook.DeleteNumberFormat(NumberFormat)
- workbook.DisplayDrawingObjects [= setting]
- workbook.DisplayInkComments [= setting]
- workbook.DocumentLibraryVersions
- workbook.EnableAutoRecover [= setting]
- workbook.EndReview
- workbook.EnvelopeVisible [= setting]
- workbook.ExclusiveAccess
- workbook.FileFormat
- workbook.FollowHyperlink(Address, [SubAddress], [NewWindow], [AddHistory], [ExtraInfo], [Method], [HeaderInfo])
- workbook.ForwardMailer( )
- workbook.FullName
- workbook.FullNameURLEncoded
- workbook.HasMailer
- workbook.HasPassword
- workbook.HasRoutingSlip [= setting]
- workbook.HighlightChangesOnScreen [= setting]
- workbook.HighlightChangesOptions([When], [Who], [Where])
- workbook.HTMLProject
- workbook.InactiveListBorderVisible [= setting]
- workbook.IsAddin [= setting]
- workbook.IsInplace
- workbook.KeepChangeHistory [= setting]
- workbook.Keywords [= setting]
- workbook.LinkInfo(Name, LinkInfo, [Type], [EditionRef])
- workbook.LinkSources([Type])
- workbook.ListChangesOnNewSheet [= setting]
- workbook.Mailer
- workbook.MergeWorkbook(Filename)
- workbook.MultiUserEditing
- workbook.Names
- workbook.NewWindow
- workbooks.Open(Filename, [UpdateLinks], [ReadOnly], [Format], [Password], [WriteResPassword], [IgnoreReadOnlyRecommended], [Origin], [Delimiter], [Editable], [Notify], [Converter], [AddToMru], [Local], [CorruptLoad])
- workbooks.OpenDatabase(Filename, [CommandText], [CommandType], [BackgroundQuery], [ImportDataAs])
- workbook.OpenLinks(Name, [ReadOnly], [Type])
- workbooks.OpenText(Filename, [Origin], [StartRow], [DataType], [TextQualifier], [ConsecutiveDelimiter], [Tab], [Semicolon], [Comma], [Space], [Other], [OtherChar], [FieldInfo], [TextVisualLayout], [DecimalSeparator], [ThousandsSeparator], [TrailingMinusNumbers], [Local])
- workbooks.OpenXML(Filename, [Stylesheets], [LoadOption])
- workbook.Path
- workbook.PersonalViewListSettings [= setting]
- workbook.PersonalViewPrintSettings [= setting]
- workbook.PivotCaches
- workbook.PivotTableWizard([SourceType], [SourceData], [TableDestination], [TableName], [RowGrand], [ColumnGrand], [SaveData], [HasAutoFormat], [AutoPage], [Reserved], [BackgroundQuery], [OptimizeCache], [PageFieldOrder], [PageFieldWrapCount], [ReadData], [Connection])
- workbook.Post([DestName])
- workbook.PrecisionAsDisplayed [= setting]
- workbook.PrintOut([From], [To], [Copies], [Preview], [ActivePrinter], [PrintToFile], [Collate], [PrToFileName])
- workbook.PrintPreview([EnableChanges])
- workbook.PublishObjects
- workbook.PurgeChangeHistoryNow(Days, [SharingPassword])
- workbook.ReadOnly
- workbook.ReadOnlyRecommended
- workbook.RecheckSmartTags
- workbook.RefreshAll
- workbook.RejectAllChanges([When], [Who], [Where])
- workbook.ReloadAs(Encoding)
- workbook.RemovePersonalInformation [= setting]
- workbook.RemoveUser(Index)
- workbook.Reply
- workbook.ReplyAll
- workbook.ReplyWithChanges([ShowMessage])
- workbook.ResetColors
- workbook.RevisionNumber
- workbook.Route
- workbook.Routed
- workbook.RoutingSlip
- workbook.RunAutoMacros(Which)
- workbook.Save
- workbook.SaveAs([Filename], [FileFormat], [Password], [WriteResPassword], [ReadOnlyRecommended], [CreateBackup], [AccessMode], [ConflictResolution], [AddToMru], [TextCodepage], [TextVisualLayout], [Local])
- workbook.SaveAsXMLData(Filename, Map)
- workbook.SaveCopyAs([Filename])
- workbook.Saved [= setting]
- workbook.SaveLinkValues [= setting]
- workbook.SendFaxOverInternet([Recipients], [Subject], [ShowMessage])
- workbook.SendForReview([Recipients], [Subject], [ShowMessage], [IncludeAttachment])
- workbook.SendMail(Recipients, [Subject], [ReturnReceipt])
- workbook.SendMailer([FileFormat], [Priority])
- workbook.SetLinkOnData(Name, [Procedure])
- workbook.SharedWorkspace
- workbook.Sheets
- workbook.ShowConflictHistory [= setting]
- workbook.ShowPivotTableFieldList [= setting]
- workbook.SmartDocument
- workbook.SmartTagOptions
- workbook.Styles [= setting]
- workbook.Subject [= setting]
- workbook.TemplateRemoveExtData [= setting]
- workbook.Title [= setting]
- workbook.ToggleFormsDesign [= setting]
- workbook.UpdateFromFile
- workbook.UpdateLink([Name], [Type])
- workbook.UpdateLinks [= setting]
- workbook.UpdateRemoteReferences [= setting]
- workbook.UserStatus
- workbook.VBASigned
- workbook.VBProject
- workbook.WebOptions
- workbook.WebPagePreview
- workbook.Windows [= setting]
- workbook.Worksheets
- workbook.XmlImport(Url, ImportMap, [Overwrite], [Destination])
- workbook.XmlImportXml(Data, ImportMap, [Overwrite], [Destination])
- workbook.XmlMaps
- workbook.XmlNamespaces
- 8.7. RecentFile and RecentFiles Members
-
9. Working with Worksheets and Ranges
- 9.1. Work with Worksheet Objects
-
9.2. Worksheets and Worksheet Members
- worksheet.Activate( )
- worksheets.Add(Before, After, Count, Type)
- worksheet.Calculate( )
- worksheet.Cells
- worksheet.CheckSpelling(CustomDictionary, IgnoreUppercase, AlwaysSuggest, SpellLang)
- worksheet.Columns([Index])
- worksheet.Comments
- worksheet.Copy(Before, After)
- worksheet.DisplayPageBreaks
- worksheet.EnableCalculation [= setting]
- worksheet.EnableOutlining [= setting]
- worksheet.EnablePivotTable [= setting]
- worksheet.EnableSelection [= setting]
- worksheet.Hyperlinks
- worksheet.Move(Before, After)
- worksheet.Outline
- worksheet.PageSetup
- worksheet.Paste([Destination], [Link])
- worksheet.PasteSpecial([Format], [Link], [DisplayAsIcon], [IconFileName], [IconIndex], [IconLabel], [NoHTMLFormatting])
- worksheet.Protect([Password], [DrawingObjects], [Contents], [Scenarios], [UserInterfaceOnly], [AllowFormattingCells], [AllowFormattingColumns], [AllowFormattingRows], [ AllowInsertingColumns], [ AllowInsertingRows], [AllowInsertingHyperlinks], [ AllowDeletingColumns], [ AllowDeletingRows], [AllowSorting], [AllowFiltering], [AllowUsingPivotTables])
- worksheet.ProtectContents
- worksheet.ProtectDrawingObjects
- worksheet.Protection
- worksheet.ProtectionMode
- worksheet.ProtectScenarios
- worksheet.QueryTables
- worksheet.Range([Cell1], [Cell2])
- worksheet.Rows([Index])
- worksheet.Scenarios([Index])
- worksheet.ScrollArea
- worksheet.SetBackgroundPicture([Filename])
- worksheet.Shapes
- worksheet.StandardHeight
- worksheet.StandardWidth
- worksheet.Type [= setting]
- worksheet.Unprotect([Password])
- worksheet.UsedRange
- 9.3. Sheets Members
- 9.4. Work with Outlines
- 9.5. Outline Members
- 9.6. Work with Ranges
-
9.7. Range Members
- range.Activate( )
- range.AddComment( )
- range.AddIndent[= setting]
- range.Address([RowAbsolute], [ColumnAbsolute], [ReferenceStyle], [External], [RelativeTo])
- range.AllowEdit
- range.Areas([Index])
- range.AutoFill(Destination, [Type])
- range.AutoFit
- range.BorderAround([LineStyle], [Weight], [ColorIndex], [Color])
- range.Borders([Index])
- range.Calculate( )
- range.Cells([RowIndex], [ColumnIndex])
- range.Characters([Start], [Length])
- range.CheckSpelling([CustomDictionary], [IgnoreUppercase], [AlwaysSuggest], [SpellLang])
- range.Clear( )
- range.ClearContents( )
- range.ClearFormats( )
- range.Column
- range.Columns([Index])
- range.ColumnWidth
- range.Copy([Destination])
- range.CopyFromRecordset([Data, MaxRows, MaxColumns])
- range.Cut([Destination])
- range.Delete([Shift])
- range.Dependents
- range.DirectDependents
- range.DirectPrecedents
- range.End([Direction])
- range.EntireColumn
- range.EntireRow
- range.FillDown
- range.FillLeft
- range.FillRight
- range.FillUp
- range.Find(What, [After], [LookIn], [LookAt]), [SearchOrder], [SearchDirection], [MatchCase], [MatchByte], [SearchFormat])
- range.FindNext([After])
- range.FindPrevious([After])
- range.Font
- range.Formula
- range.FormulaR1C1
- range.Hidden
- range.HorizontalAlignment
- range.Hyperlinks
- range.Insert([Shift])
- range.Interior
- range.Item(RowIndex, [ColumnIndex])
- range.Justify
- range.Locked
- range.Merge([Across])
- range.MergeArea
- range.MergeCells
- range.Next
- range.NoteText([Text], [Start], [Length])
- range.NumberFormat
- range.NumberFormatLocal
- range.Offset([RowOffset], [ColumnOffset])
- range.PageBreak
- range.PasteSpecial([Paste], [Operation], [SkipBlanks], [Transpose])
- range.Precedents
- range.Previous
- range.PrintOut([From], [To], [Copies], [Preview], [ActivePrinter], [PrintToFile], [Collate], [PrToFileName])
- range.PrintPreview
- range.Replace(What, Replacement, [LookAt]), [SearchOrder], [MatchCase], [MatchByte], [SearchFormat], [ReplaceFormat])
- range.Resize([RowSize]), [ColumnSize])
- range.Row
- range.RowDifferences(Comparison)
- range.RowHeight
- range.Rows([Index])
- range.Select
- range.Show
- range.ShowDependents([Remove])
- range.ShowDetail [= setting]
- range.ShowErrors( )
- range.ShowPrecedents([Remove])
- range.ShrinkToFit [= setting]
- range.Sort([Key1]), [Order1], [Key2], [Type], [Order2], [Key3], [Order3], [Header], [OrderCustom], [MatchCase], [Orientation], [SortMethod], [DataOption1], [DataOption2], [DataOption3])
- range.SpecialCells(Type, [Value])
- range.Style
- range.Table([RowInput], [ColumnInput])
- range.Text
- range.TextToColumns([Destination]), [DataType], [TextQualifier], [ConsecutiveDelimiter], [Tab], [Semicolon], [Comma], [Space], [Other], [OtherChar], [FieldInfo], [DecimalSeparator], [ThousandsSeparator], [TrailingMinusNumbers])
- range.UnMerge
- range.UseStandardHeight [= setting]
- range.UseStandardWidth [= setting]
- range.Value([RangeValueDataType]) [= setting]
- range.VerticalAlignment
- range.Worksheet
- range.WrapText[= setting]
- 9.8. Work with Scenario Objects
- 9.9. Scenario and Scenarios Members
- 9.10. Resources
-
10. Linking and Embedding
- 10.1. Add Comments
- 10.2. Use Hyperlinks
- 10.3. Link and Embed Objects
- 10.4. Speak
- 10.5. Comment and Comments Members
-
10.6. Hyperlink and Hyperlinks Members
- hyperlinks.Add(Anchor, Address, [SubAddress], [ScreenTip], [TextToDisplay])
- hyperlink.Address [= setting]
- hyperlink.AddToFavorites( )
- hyperlink.CreateNewDocument(Filename, EditNow, Overwrite)
- hyperlink.EmailSubject [= setting]
- hyperlink.Follow([NewWindow], [AddHistory], [ExtraInfo], [Method], [HeaderInfo])
- hyperlink.Range
- hyperlink.ScreenTip [= setting]
- hyperlink.Shape
- hyperlink.SubAddress [= setting]
- hyperlink.TextToDisplay [= setting]
- hyperlink.Type
-
10.7. OleObject and OleObjects Members
- oleobject.Add([ClassType], [Filename], [Link], [DisplayAsIcon], [IconFileName], [IconIndex], [IconLabel], [Left], [Top], [Width], [Height])
- oleobject.AutoLoad [= setting]
- oleobject.AutoUpdate [= setting]
- oleobject.BottomRightCell
- oleobject.BringToFront( )
- oleobject.Copy( )
- oleobject.CopyPicture([Appearance], [Format])
- oleobject.Duplicate( )
- oleobjects.Group( )
- oleobject.LinkedCell
- oleobject.ListFillRange [= setting]
- oleObject.Object
- oleobject.OLEType
- oleobject.OnAction [= setting]
- oleobject.Placement [= xlPlacement]
- oleobject.progID [= setting]
- oleobject.Shadow [= setting]
- oleobject.ShapeRange
- oleobject.SourceName
- oleobject.Update( )
- oleobject.Verb([Verb])
- oleobject.ZOrder
- 10.8. OLEFormat Members
- 10.9. Speech Members
- 10.10. UsedObjects Members
-
11. Printing and Publishing
- 11.1. Print and Preview
- 11.2. Control Paging
- 11.3. Change Printer Settings
- 11.4. Filter Ranges
- 11.5. Save and Display Views
- 11.6. Publish to the Web
- 11.7. AutoFilter Members
- 11.8. Filter and Filters Members
- 11.9. CustomView and CustomViews Members
- 11.10. HPageBreak, HPageBreaks, VPageBreak, VPageBreaks Members
-
11.11. PageSetup Members
- pagesetup.BlackAndWhite [= setting]
- pagesetup.BottomMargin [= setting]
- pagesetup.CenterFooter [= setting]
- pagesetup.CenterFooterPicture
- pagesetup.CenterHeader [= setting]
- pagesetup.CenterHeaderPicture
- pagesetup.CenterHorizontally [= setting]
- pagesetup.CenterVertically [= setting]
- pagesetup.ChartSize [= setting]
- pagesetup.Draft [= setting]
- pagesetup.FirstPageNumber [= setting]
- pagesetup.FitToPagesTall [= setting]
- pagesetup.FitToPagesWide [= setting]
- pagesetup.FooterMargin [= setting]
- pagesetup.HeaderMargin [= setting]
- pagesetup.LeftFooter [= setting]
- pagesetup.LeftFooterPicture
- pagesetup.LeftHeader [= setting]
- pagesetup.LeftHeaderPicture
- pagesetup.LeftMargin [= setting]
- pagesetup.Order [= setting]
- pagesetup.Orientation [= setting]
- pagesetup.PaperSize [= setting]
- pagesetup.PrintArea [= setting]
- pagesetup.PrintComments [= setting]
- pagesetup.PrintErrors [= setting]
- pagesetup.PrintGridlines [= setting]
- pagesetup.PrintHeadings [= setting]
- pagesetup.PrintNotes [= setting]
- pagesetup.PrintQuality(index) [= setting]
- pagesetup.PrintTitleColumns [= setting]
- pagesetup.PrintTitleRows [= setting]
- pagesetup.RightFooter [= setting]
- pagesetup.RightFooterPicture
- pagesetup.RightHeader [= setting]
- pagesetup.RightHeaderPicture
- pagesetup.RightMargin [= setting]
- pagesetup.TopMargin [= setting]
- pagesetup.Zoom [= setting]
- 11.12. Graphic Members
-
11.13. PublishObject and PublishObjects Members
- publishobjects.Add(SourceType, Filename, [Sheet], [Source], [HtmlType], [DivID], [Title])
- publishobject.AutoRepublish [= setting]
- publishobject.DivID
- publishobject.Filename [= setting]
- publishobject.HtmlType [= setting]
- publishobjects.Publish([Create])
- publishobject.Sheet
- publishobject.Source
- publishobject.SourceType
- publishobject.Title [= setting]
-
11.14. WebOptions and DefaultWebOptions Members
- options.AllowPNG [= setting]
- defaultweboptions.AlwaysSaveInDefaultEncoding [= setting]
- defaultweboptions.CheckIfOfficeIsHTMLEditor [= setting]
- options.DownloadComponents [= setting]
- options.Encoding [= msoEncoding]
- options.FolderSuffix
- defaultweboptions.Fonts
- defaultweboptions.LoadPictures [= setting]
- options.LocationOfComponents [= setting]
- options.OrganizeInFolder [= setting]
- options.RelyOnCSS [= setting]
- options.RelyOnVML [= setting]
- defaultweboptions.SaveHiddenData [= setting]
- defaultweboptions.SaveNewWebPagesAsWebArchives [= setting]
- options.ScreenSize [= msoScreenSize]
- options.TargetBrowser [= msoTargetBrowser]
- defaultweboptions.UpdateLinksOnSave [= setting]
- options.UseLongFileNames [= setting]
-
12. Loading and Manipulating Data
- 12.1. Working with QueryTable Objects
-
12.2. QueryTable and QueryTables Members
- querytables.Add(Connection, Destination, [Sql])
- querytable.AdjustColumnWidth [= setting]
- querytable.BackgroundQuery[= setting]
- querytable.CancelRefresh
- querytable.CommandText[= setting]
- querytable.CommandType[= setting]
- querytable.Connection[= setting]
- querytable.Delete
- querytable.Destination
- querytable.EnableEditing[= setting]
- querytable.EnableRefresh[= setting]
- querytable.FetchedRowOverflow[= setting]
- querytable.FieldNames[= setting]
- querytable.FillAdjacentFormulas[= setting]
- querytable.MaintainConnection[= setting]
- querytable.Parameters
- querytable.PreserveColumnInfo[= setting]
- querytable.PreserveFormatting[= setting]
- querytable.QueryType[= setting]
- querytable.Recordset[= setting]
- querytable.Refresh([BackgroundQuery])
- querytable.Refreshing
- querytable.RefreshOnFileOpen[= setting]
- querytable.RefreshPeriod[= setting]
- querytable.RefreshStyle[= setting]
- querytable.ResetTimer
- querytable.ResultRange
- querytable.RowNumbers[= setting]
- querytable.SavePassword[= setting]
- querytable.TextFileColumnDataTypes[= setting]
- querytable.TextFileCommaDelimiter[= setting]
- querytable.TextFileConsecutiveDelimiter[= setting]
- querytable.TextFileDecimalSeparator[= setting]
- querytable.TextFileFixedColumnWidths[= setting]
- querytable.TextFileOtherDelimiter[= setting]
- querytable.TextFileParseType[= setting]
- querytable.TextFilePlatform[= setting]
- querytable.TextFilePromptOnRefresh[= setting]
- querytable.TextFileSemicolonDelimiter[= setting]
- querytable.TextFileSpaceDelimiter[= setting]
- querytable.TextFileTabDelimiter[= setting]
- querytable.TextFileTextQualifier[= setting]
- querytable.TextFileThousandsSeparator[= setting]
- querytable.TextFileTrailingMinusNumbers[= setting]
- querytable.TextFileVisualLayout[= setting]
- 12.3. Working with Parameter Objects
- 12.4. Parameter Members
- 12.5. Working with ADO and DAO
-
12.6. ADO Objects and Members
- 12.6.1. ADO.Command Members
- 12.6.2. ADO.Connection Members
- 12.6.3. ADO.Field and ADO.Fields Members
- 12.6.4. ADO.Parameter and ADO.Parameters Members
- 12.6.5. ADO.Record Members
-
12.6.6. ADO.Recordset Members
- recordset.AbsolutePosition[= setting]
- recordset.ActiveCommand[= setting]
- recordset.ActiveConnection [= setting]
- recordset.AddNew([FieldList], [Values])
- recordset.BOF[= setting]
- recordset.Cancel
- recordset.CancelUpdate
- recordset.Delete([AffectRecords])
- recordset.EOF[= setting]
- recordset.Filter[= setting]
- recordset.MoveFirst
- recordset.MoveLast
- recordset.MoveNext
- recordset.MovePrevious
- recordset.Open([Source], [ActiveConnection], [CursorType] , [LockType] , [Options])
- recordset.RecordCount[= setting]
- recordset.Requery
- recordset.Source[= setting]
- recordset.Update([Fields], [Value])
- 12.7. DAO Objects and Members
- 12.8. DAO.Database and DAO.Databases Members
- 12.9. DAO.Document and DAO.Documents Members
- 12.10. DAO.QueryDef and DAO.QueryDefs Members
- 12.11. DAO.Recordset and DAO.Recordsets Members
-
13. Analyzing Data with Pivot Tables
- 13.1. Quick Guide to Pivot Tables
- 13.2. Program Pivot Tables
-
13.3. PivotTable and PivotTables Members
- pivottables.Add(PivotCache, TableDestination, [TableName], [ReadData], [DefaultVersion])
- pivottable.AddDataField(Field, [Caption], [Function])
- pivottable.AddFields([RowFields], [ColumnFields], [PageFields], [AddToTable])
- pivottable.CacheIndex [= setting]
- pivottable.CalculatedFields( )
- pivottable.CalculatedMembers
- pivottable.ColumnFields
- pivottable.ColumnGrand [= setting]
- pivottable.ColumnRange
- pivottable.CreateCubeFile(File, [Measures], [Levels], [Members], [Properties])
- pivottable.CubeFields
- pivottable.DataBodyRange
- pivottable.DataFields
- pivottable.DataLabelRange
- pivottable.DataPivotField
- pivottable.DisplayEmptyColumn [= setting]
- pivottable.DisplayEmptyRow [= setting]
- pivottable.DisplayErrorString [= setting]
- pivottable.DisplayImmediateItems [= setting]
- pivottable.DisplayNullString [= setting]
- pivottable.EnableDataValueEditing [= setting]
- pivottable.EnableDrilldown [= setting]
- pivottable.EnableFieldDialog [= setting]
- pivottable.EnableFieldList [= setting]
- pivottable.EnableWizard [= setting]
- pivottable.ErrorString [= setting]
- pivottable.Format(Format)
- pivottable.GetData(Name)
- pivottable.GetPivotData([DataField], [Field1], [Item1], [Fieldn], [Itemn])
- pivottable.GrandTotalName [= setting]
- pivottable.HasAutoFormat [= setting]
- pivottable.HiddenFields
- pivottable.InnerDetail [= setting]
- pivottable.ListFormulas( )
- pivottable.ManualUpdate [= setting]
- pivottable.MDX
- pivottable.MergeLabels [= setting]
- pivottable.NullString [= setting]
- pivottable.PageFieldOrder [= xlOrder]
- pivottable.PageFields
- pivottable.PageFieldWrapCount [= setting]
- pivottable.PageRange
- pivottable.PageRangeCells
- pivottable.PivotCache( )
- pivottable.PivotFields
- pivottable.PivotFormulas
- pivottable.PivotSelect(Name, [Mode], [UseStandardName])
- pivottable.PivotSelection [= setting]
- pivottable.PivotSelectionStandard [= setting]
- pivottable.PivotTableWizard([SourceType], [SourceData], [TableDestination], [TableName], [RowGrand], [ColumnGrand], [SaveData], [HasAutoFormat], [AutoPage], [Reserved], [BackgroundQuery], [OptimizeCache], [PageFieldOrder], [PageFieldWrapCount], [ReadData], [Connection])
- pivottable.PreserveFormatting [= setting]
- pivottable.PrintTitles [= setting]
- pivottable.RefreshDate
- pivottable.RefreshName
- pivottable.RefreshTable( )
- pivottable.RepeatItemsOnEachPrintedPage [= setting]
- pivottable.RowFields
- pivottable.RowGrand [= setting]
- pivottable.RowRange
- pivottable.SaveData [= setting]
- pivottable.SelectionMode [= xlPTSelectionMode]
- pivottable.ShowCellBackgroundFromOLAP [= setting]
- pivottable.ShowPageMultipleItemLabel [= setting]
- pivottable.ShowPages([PageField])
- pivottable.SourceData
- pivottable.SubtotalHiddenPageItems [= setting]
- pivottable.TableRange1
- pivottable.TableRange2
- pivottable.TableStyle [= setting]
- pivottable.TotalsAnnotation [= setting]
- pivottable.Update( )
- pivottable.VacatedStyle [= setting]
- pivottable.Value [= setting]
- pivottable.Version
- pivottable.ViewCalculatedMembers [= setting]
- pivottable.VisibleFields
- pivottable.VisualTotals [= setting]
-
13.4. PivotCache and PivotCaches Members
- pivotcaches.Add(SourceType, [SourceData])
- pivotcache.ADOConnection
- pivotcache.BackgroundQuery [= setting]
- pivotcache.CommandText [= setting]
- pivotcache.CommandType [= xlCmdType]
- pivotcache.Connection [= setting]
- pivotcache.CreatePivotTable(TableDestination, [TableName], [ReadData], [DefaultVersion])
- pivotcache.EnableRefresh [= setting]
- pivotcache.IsConnected
- pivotcache.LocalConnection [= setting]
- pivotcache.MaintainConnection [= setting]
- pivotcache.MakeConnection( )
- pivotcache.MemoryUsed
- pivotcache.MissingItemsLimit [= setting]
- pivotcache.OLAP
- pivotcache.OptimizeCache [= setting]
- pivotcache.QueryType
- pivotcache.RecordCount
- pivotcache.Recordset [= setting]
- pivotcache.Refresh( )
- pivotcache.RefreshOnFileOpen [= setting]
- pivotcache.RefreshPeriod [= setting]
- pivotcache.ResetTimer( )
- pivotcache.RobustConnect [= xlRobustConnect]
- pivotcache.SaveAsODC(ODCFileName, [Description], [Keywords])
- pivotcache.SavePassword [= setting]
- pivotcache.SourceConnectionFile [= setting]
- pivotcache.SourceDataFile
- pivotcache.SourceType
- pivotcache.Sql [= setting]
- pivotcache.UseLocalConnection [= setting]
-
13.5. PivotField and PivotFields Members
- pivotfield.AddPageItem(Item, [ClearList])
- pivotfield.AutoShow(Type, Range, Count, Field)
- pivotfield.AutoShowCount
- pivotfield.AutoShowField
- pivotfield.AutoShowRange
- pivotfield.AutoShowType
- pivotfield.AutoSort(Order, Field)
- pivotfield.AutoSortField
- pivotfield.AutoSortOrder
- pivotfield.BaseField [= setting]
- pivotfield.BaseItem [= setting]
- pivotfield.CalculatedItems( )
- pivotfield.Calculation [= xlPivotFieldCalculation]
- pivotfield.Caption [= setting]
- pivotfield.ChildField
- pivotfield.ChildItems
- pivotfield.CubeField
- pivotfield.CurrentPage [= setting]
- pivotfield.CurrentPageList [= setting]
- pivotfield.CurrentPageName [= setting]
- pivotfield.DatabaseSort [= setting]
- pivotfield.DataRange
- pivotfield.DataType
- pivotfield.Delete( )
- pivotfield.DragToColumn [= setting]
- pivotfield.DragToData [= setting]
- pivotfield.DragToHide [= setting]
- pivotfield.DragToPage [= setting]
- pivotfield.DragToRow [= setting]
- pivotfield.DrilledDown [= setting]
- pivotfield.EnableItemSelection [= setting]
- pivotfield.Formula [= setting]
- pivotfield.Function [= xlConsolidationFunction]
- pivotfield.GroupLevel
- pivotfield.HiddenItems
- pivotfield.HiddenItemsList [= setting]
- pivotfield.IsCalculated
- pivotfield.IsMemberProperty
- pivotfield.LabelRange
- pivotfield.LayoutBlankLine [= setting]
- pivotfield.LayoutForm [= xlLayoutFormType]
- pivotfield.LayoutPageBreak [= setting]
- pivotfield.LayoutSubtotalLocation [= XlSubtototalLocationType]
- pivotfield.NumberFormat [= setting]
- pivotfield.Orientation [= xlPivotFieldOrientation]
- pivotfield.ParentField
- pivotfield.PivotItems([Index])
- pivotfield.Position [= setting]
- pivotfield.PropertyOrder [= setting]
- pivotfield.PropertyParentField
- pivotfield.ServerBased [= setting]
- pivotfield.ShowAllItems [= setting]
- pivotfield.SourceName
- pivotfield.StandardFormula [= setting]
- pivotfield.SubtotalName [= setting]
- pivotfield.Subtotals [= setting]
- pivotfield.TotalLevels
- pivotfield.VisibleItems
- 13.6. CalculatedFields Members
- 13.7. CalculatedItems Members
- 13.8. PivotCell Members
- 13.9. PivotFormula and PivotFormulas Members
- 13.10. PivotItem and PivotItems Members
- 13.11. PivotItemList Members
- 13.12. PivotLayout Members
- 13.13. CubeField and CubeFields Members
- 13.14. CalculatedMember and CalculatedMembers Members
-
14. Sharing Data Using Lists
- 14.1. Use Lists
- 14.2. ListObject and ListObjects Members
- 14.3. ListRow and ListRows Members
- 14.4. ListColumn and ListColumns Members
- 14.5. ListDataFormat Members
- 14.6. Use the Lists Web Service
-
14.7. Lists Web Service Members
- wslists.AddAttachment (listName, listItemID, fileName, attachment)
- wslists.AddList (listName, description, templateID)
- wslists.DeleteAttachment (listName, listItemID, url)
- wslists.DeleteList (listName)
- wslists.GetAttachmentCollection (listName, listItemID)
- wslists.GetList (listName)
- wslists.GetListAndView (listName, viewName)
- wslists.GetListCollection ( )
- wslists.GetListItemChanges (listName, viewFields, since, contains)
- wslists.GetListItems (listName, viewName, query, viewFields, rowLimit, queryOptions)
- wslists.UpdateList (listName, listProperties, newFields, updateFields, deleteFields, listVersion)
- wslists.UpdateListItems (listName, updates)
- 14.8. Resources
-
15. Working with XML
- 15.1. Understand XML
- 15.2. Save Workbooks as XML
- 15.3. Use XML Maps
- 15.4. Program with XML Maps
-
15.5. XmlMap and XmlMaps Members
- xmlmaps.Add(Schema, [RootElementName])
- xmlmap.AdjustColumnWidth [= setting]
- xmlmap.AppendOnImport [= setting]
- xmlmap.DataBinding
- xmlmap.Delete
- xmlmap.Export(Url, [Overwrite])
- xmlmap.ExportXml(Data)
- xmlmap.Import(Url, [Overwrite])
- xmlmap.ImportXml(Data, [Overwrite])
- xmlmap.IsExportable
- xmlmap.PreserveColumnFilter [= setting]
- xmlmap.PreserveNumberFormatting [= setting]
- xmlmap.RootElementName
- xmlmap.RootElementNamespace
- xmlmap.SaveDataSourceDefinition [= setting]
- xmlmap.Schemas
- xmlmap.ShowImportExportValidationErrors [= setting]
- 15.6. XmlDataBinding Members
- 15.7. XmlNamespace and XmlNamespaces Members
- 15.8. XmlSchema and XmlSchemas Members
- 15.9. Get an XML Map from a List or Range
- 15.10. XPath Members
- 15.11. Resources
-
16. Charting
- 16.1. Navigate Chart Objects
- 16.2. Create Charts Quickly
- 16.3. Embed Charts
- 16.4. Create More Complex Charts
- 16.5. Choose Chart Type
- 16.6. Create Combo Charts
- 16.7. Add Titles and Labels
- 16.8. Plot a Series
- 16.9. Respond to Chart Events
-
16.10. Chart and Charts Members
- chart.Add([Before], [After], [Count])
- chart.ApplyCustomType(ChartType, [TypeName])
- chart.ApplyDataLabels([Type], [LegendKey], [AutoText], [HasLeaderLines], [ShowSeriesName], [ShowCategoryName], [ShowValues], [ShowPercentage], [ShowBubbleSize], [Separator])
- chart.Area3DGroup
- chart.AreaGroups([Index])
- chart.AutoFormat(Gallery, [Format])
- chart.AutoScaling [= setting]
- chart.Axes([Type], [AxisGroup])
- chart.Bar3DGroup
- chart.BarGroups([Index])
- chart.BarShape [= xlBarShape]
- chart.ChartArea
- chart.ChartGroups([Index])
- chart.ChartObjects([Index])
- chart.ChartTitle
- chart.ChartType [= xlChartType]
- chart.ChartWizard([Source], [Gallery], [Format], [PlotBy], [CategoryLabels], [SeriesLabels], [HasLegend], [Title], [CategoryTitle], [ValueTitle], [ExtraTitle])
- chart.CodeName
- chart.Column3DGroup
- chart.ColumnGroups([Index])
- chart.CopyPicture([Appearance], [Format], [Size])
- chart.Corners
- chart.CreatePublisher([Edition], [Appearance], [Size], [ContainsPICT], [ContainsBIFF], [ContainsRTF], [ContainsVALU])
- chart.DataTable
- chart.DepthPercent [= setting]
- chart.Deselect( )
- chart.DisplayBlanksAs [= xlDisplayBlanksAs]
- chart.DoughnutGroups([Index])
- chart.Elevation [= setting]
- chart.Floor
- chart.GapDepth [= setting]
- chart.GetChartElement(x, y, ElementID, Arg1, Arg2)
- chart.HasAxis(xlAxisGroup, xlAxisType) [= setting]
- chart.HasDataTable [= setting]
- chart.HasLegend [= setting]
- chart.HasPivotFields [= setting]
- chart.HasTitle [= setting]
- chart.HeightPercent [= setting]
- chart.Legend
- chart.Line3DGroup
- chart.LineGroups([Index])
- chart.Location(Where, [Name])
- chart.Perspective [= setting]
- chart.Pie3DGroup
- chart.PieGroups([Index])
- chart.PivotLayout
- chart.PlotArea
- chart.PlotBy [= xlRowCol]
- chart.PlotVisibleOnly [= setting]
- chart.Refresh( )
- chart.RightAngleAxes [= setting]
- chart.Rotation [= setting]
- chart.Select([Replace])
- chart.SeriesCollection([Index])
- chart.SetBackgroundPicture(Filename)
- chart.SetSourceData(Source, [PlotBy])
- chart.ShowWindow [= setting]
- chart.SizeWithWindow [= setting]
- chart.SurfaceGroup
- chart.Walls
- chart.WallsAndGridlines2D [= setting]
- chart.XYGroups([Index])
- 16.11. ChartObject and ChartObjects Members
-
16.12. ChartGroup and ChartGroups Members
- chartgroup.BubbleScale [= setting]
- chartgroup.DoughnutHoleSize [= setting]
- chartgroup.DownBars
- chartgroup.DropLines
- chartgroup.FirstSliceAngle [= setting]
- chartgroup.GapWidth [= setting]
- chartgroup.Has3DShading [= setting]
- chartgroup.HasDropLines [= setting]
- chartgroup.HasHiLoLines [= setting]
- chartgroup.HasRadarAxisLabels [= setting]
- chartgroup.HasSeriesLines [= setting]
- chartgroup.HasUpDownBars [= setting]
- chartgroup.HiLoLines
- chartgroup.Overlap [= setting]
- chartgroup.RadarAxisLabels
- chartgroup.SecondPlotSize [= setting]
- chartgroup.SeriesLines
- chartgroup.ShowNegativeBubbles [= setting]
- chartgroup.SizeRepresents [= xlSizeRepresents]
- chartgroup.SplitType [= xlSplitType]
- chartgroup.SplitValue [= setting]
- chartgroup.UpBars
- chartgroup.VaryByCategories [= setting]
- 16.13. SeriesLines Members
-
16.14. Axes and Axis Members
- axis.AxisBetweenCategories [= setting]
- axis.AxisGroup
- axis.AxisTitle
- axis.BaseUnit [= setting]
- axis.BaseUnitIsAuto [= setting]
- axis.CategoryNames [= setting]
- axis.CategoryType [= xlCategoryType]
- axis.Crosses [= xlAxisCrosses]
- axis.CrossesAt [= setting]
- axis.DisplayUnit [= xlDisplayUnit]
- axis.DisplayUnitCustom [= setting]
- axis.DisplayUnitLabel
- axis.HasDisplayUnitLabel [= setting]
- axis.HasMajorGridlines [= setting]
- axis.HasMinorGridlines [= setting]
- axis.HasTitle [= setting]
- axes.[Item](Type, [AxisGroup])
- axis.MajorGridlines
- axis.MajorTickMark [= xlTickMark]
- axis.MajorUnit [= setting]
- axis.MajorUnitIsAuto [= setting]
- axis.MajorUnitScale [= xlTimeUnit]
- axis.MaximumScale [= setting]
- axis.MaximumScaleIsAuto [= setting]
- axis.MinimumScale [= setting]
- axis.MinimumScaleIsAuto [= setting]
- axis.MinorGridlines
- axis.MinorTickMark [= xlTickMark]
- axis.MinorUnit [= setting]
- axis.MinorUnitIsAuto [= setting]
- axis.MinorUnitScale [= xlTimeUnit]
- axis.ReversePlotOrder [= setting]
- axis.ScaleType [= xlScaleType]
- axis.TickLabelPosition [= xlTickLabelPosition]
- axis.TickLabels
- axis.TickLabelSpacing [= setting]
- axis.TickMarkSpacing [= setting]
- axis.Type
- 16.15. DataTable Members
-
16.16. Series and SeriesCollection Members
- seriescollection.Add(Source, [Rowcol], [SeriesLabels], [CategoryLabels], [Replace])
- series.ApplyCustomType(ChartType)
- series.ApplyDataLabels([Type], [LegendKey], [AutoText], [HasLeaderLines], [ShowSeriesName], [ShowCategoryName], [ShowValues], [ShowPercentage], [ShowBubbleSize], [Separator])
- series.ApplyPictToEnd [= setting]
- series.ApplyPictToFront [= setting]
- series.ApplyPictToSides [= setting]
- series.AxisGroup [= xlAxisGroup]
- series.ChartType [= xlChartType]
- series.ClearFormats( )
- series.DataLabels([Index])
- series.ErrorBar(Direction, Include, Type, [Amount], [MinusValues])
- series.ErrorBars
- series.Explosion [= setting]
- seriescollection.Extend(Source, [Rowcol], [CategoryLabels])
- series.Fill
- series.Formula [= setting]
- End Function series.FormulaLocal [= setting]
- series.FormulaR1C1 [= setting]
- series.FormulaR1C1Local [= setting]
- series.Has3DEffect [= setting]
- series.HasDataLabels [= setting]
- series.HasErrorBars [= setting]
- series.HasLeaderLines [= setting]
- series.InvertIfNegative [= setting]
- series.LeaderLines
- series.MarkerBackgroundColor [= setting]
- series.MarkerBackgroundColorIndex [= setting]
- series.MarkerForegroundColor [= setting]
- series.MarkerForegroundColorIndex [= setting]
- series.MarkerSize [= setting]
- series.MarkerStyle [= xlMarkerStyle]
- seriescollection.NewSeries( )
- seriescollection.Paste([Rowcol], [SeriesLabels], [CategoryLabels], [Replace], [NewSeries])
- series.PictureType [= xlChartPictureType]
- series.PictureUnit [= setting]
- series.PlotOrder [= setting]
- series.Points([Index])
- series.Smooth [= setting]
- series.Trendlines([Index])
- series.Values [= setting]
- series.XValues [= setting]
- 16.17. Point and Points Members
-
17. Formatting Charts
- 17.1. Format Titles and Labels
- 17.2. Change Backgrounds and Fonts
- 17.3. Add Trendlines
- 17.4. Add Series Lines and Bars
- 17.5. ChartTitle, AxisTitle, and DisplayUnitLabel Members
-
17.6. DataLabel and DataLabels Members
- datalabel AutoText [= setting]
- datalabels.NumberFormat [= setting]
- datalabel.NumberFormatLinked [= setting]
- datalabel.NumberFormatLocal [= setting]
- datalabel.Position [= xlDataLabelPosition]
- datalabel.Separator [= setting]
- datalabel.ShowBubbleSize [= setting]
- datalabel.ShowCategoryName [= setting]
- datalabel.ShowLegendKey [= setting]
- datalabel.ShowPercentage [= setting]
- datalabel.ShowSeriesName [= setting]
- datalabel.ShowValue [= setting]
- 17.7. LeaderLines Members
- 17.8. ChartArea Members
-
17.9. ChartFillFormat Members
- chartfillformat.BackColor
- chartfillformat.ForeColor
- chartfillformat.GradientColorType
- chartfillformat.GradientDegree
- chartfillformat.GradientStyle
- chartfillformat.GradientVariant
- chartfillformat.OneColorGradient(Style, Variant, Degree)
- chartfillformat.Pattern
- chartfillformat.Patterned(Pattern)
- chartfillformat.PresetGradient(Style, Variant, PresetGradientType)
- chartfillformat.PresetGradientType
- chartfillformat.PresetTexture
- chartfillformat.PresetTextured(PresetTexture)
- chartfillformat.Solid( )
- chartfillformat.TextureName
- chartfillformat.TextureType
- chartfillformat.TwoColorGradient(Style, Variant)
- chartfillformat.UserPicture(PictureFile)
- chartfillformat.UserTextured(TextureFile)
- 17.10. ChartColorFormat Members
- 17.11. DropLines and HiLoLines Members
- 17.12. DownBars and UpBars Members
- 17.13. ErrorBars Members
- 17.14. Legend Members
- 17.15. LegendEntry and LegendEntries Members
- 17.16. LegendKey Members
- 17.17. Gridlines Members
-
17.18. TickLabels Members
- ticklabels.Alignment [= setting]
- ticklabels.Depth
- ticklabels.Font
- ticklabels.NumberFormat [= setting]
- ticklabels.NumberFormatLinked [= setting]
- ticklabels.NumberFormatLocal [= setting]
- ticklabels.Offset [= setting]
- ticklabels.Orientation [= xlTickLabelOrientation]
- ticklabels.ReadingOrder [= setting]
-
17.19. Trendline and Trendlines Members
- trendlines.Add([Type], [Order], [Period], [Forward], [Backward], [Intercept], [DisplayEquation], [DisplayRSquared], [Name])
- trendline.Backward [= setting]
- trendline.ClearFormats( )
- trendline.DataLabel
- trendline.DisplayEquation [= setting]
- trendline.DisplayRSquared [= setting]
- trendline.Forward [= setting]
- trendline.Intercept [= setting]
- trendline.InterceptIsAuto [= setting]
- trendline.Name [= setting]
- trendline.NameIsAuto [= setting]
- trendline.Order [= setting]
- trendline.Period [= setting]
- 17.20. PlotArea Members
- 17.21. Floor Members
- 17.22. Walls Members
- 17.23. Corners Members
-
18. Drawing Graphics
- 18.1. Draw in Excel
- 18.2. Create Diagrams
- 18.3. Program with Drawing Objects
- 18.4. Program Diagrams
-
18.5. Shape, ShapeRange, and Shapes Members
- shapes.AddCallout(Type, Left, Top, Width, Height)
- shapes.AddConnector(Type, BeginX, BeginY, EndX, EndY)
- shapes.AddCurve(SafeArrayOfPoints)
- shapes.AddLabel(Orientation, Left, Top, Width, Height)
- shapes.AddLine(BeginX, BeginY, EndX, EndY)
- shapes.AddPicture(Filename, LinkToFile, SaveWithDocument, Left, Top, Width, Height)
- shapes.AddPolyline(SafeArrayOfPoints)
- shapes.AddShape(Type, Left, Top, Width, Height)
- shapes.AddTextbox(Orientation, Left, Top, Width, Height)
- shapes.AddTextEffect(PresetTextEffect, Text, FontName, FontSize, FontBold, FontItalic, Left, Top)
- shape.Adjustments
- shaperange.Align(AlignCmd, RelativeTo)
- shape.AlternativeText [= setting]
- shape.Apply( )
- shape.AutoShapeType [= msoAutoShapeType]
- shape.BlackWhiteMode [= msoBlackWhiteMode]
- shapes.BuildFreeform(EditingType, X1, Y1)
- shape.Callout
- shape.ConnectionSiteCount
- shape.Connector
- shape.ConnectorFormat
- shape.ControlFormat
- shaperange.Distribute(DistributeCmd, RelativeTo)
- shape.Duplicate( )
- shape.Fill
- shape.Flip(FlipCmd)
- shape.FormControlType
- shaperange.Group( )
- shape.GroupItems
- shape.HorizontalFlip
- shape.Hyperlink
- shape.ID
- shape.IncrementLeft(Increment)
- shape.IncrementRotation(Increment)
- shape.IncrementTop(Increment)
- shape.Line
- shape.LinkFormat
- shape.LockAspectRatio [= setting]
- shape.Locked [= setting]
- shape.ParentGroup
- shape.PickUp( )
- shape.PictureFormat
- shape.Placement [= xlPlacement]
- shapes.Range(Index)
- shaperange.Regroup( )
- shape.RerouteConnections( )
- shape.Rotation [= setting]
- shapes.SelectAll( )
- shape.SetShapesDefaultProperties( )
- shape.Shadow
- shape.TextEffect
- shape.TextFrame
- shape.ThreeD
- shape.Type
- shape.Ungroup( )
- shape.VerticalFlip
- shape.Vertices
- 18.6. Adjustments Members
-
18.7. CalloutFormat Members
- callout.Accent [= setting]
- callout.Angle [= msoCalloutAngleType]
- callout.AutoAttach [= setting]
- callout.AutoLength
- callout.AutomaticLength( )
- callout.Border [= setting]
- callout.CustomDrop(Drop)
- callout.CustomLength(Length)
- callout.Drop
- callout.DropType
- callout.Gap [= setting]
- callout.Length
- callout.PresetDrop(DropType)
- callout.Type [= msoCalloutType]
- 18.8. ColorFormat Members
-
18.9. ConnectorFormat Members
- connectorformat.BeginConnect(ConnectedShape, ConnectionSite)
- connectorformat.BeginConnected
- connectorformat.BeginConnectedShape
- connectorformat.BeginConnectionSite
- connectorformat.BeginDisconnect( )
- connectorformat.EndConnect(ConnectedShape, ConnectionSite)
- connectorformat.EndConnected
- connectorformat.EndConnectedShape
- connectorformat.EndConnectionSite
- connectorformat.EndDisconnect( )
- connectorformat.Type [= msoConnectorType]
- 18.10. ControlFormat Members
- 18.11. FillFormat Members
- 18.12. FreeFormBuilder
- 18.13. GroupShapes Members
- 18.14. LineFormat Members
- 18.15. LinkFormat Members
-
18.16. PictureFormat Members
- pictureformat.Brightness [= setting]
- pictureformat.ColorType [= msoPictureColorType]
- pictureformat.Contrast [= setting]
- pictureformat.CropBottom [= setting]
- pictureformat.CropLeft [= setting]
- pictureformat.CropRight [= setting]
- pictureformat.CropTop [= setting]
- pictureformat.IncrementBrightness(Increment)
- pictureformat.IncrementContrast(Increment)
- pictureformat.TransparencyColor [= setting]
- pictureformat.TransparentBackground [= setting]
- 18.17. ShadowFormat
- 18.18. ShapeNode and ShapeNodes Members
-
18.19. TextFrame
- textframe.AutoMargins [= setting]
- textframe.AutoSize [= setting]
- textframe.Characters([Start], [Length])
- textframe.HorizontalAlignment [= xlHAlign]
- textframe.MarginBottom [= setting]
- textframe.MarginLeft [= setting]
- textframe.MarginRight [= setting]
- textframe.MarginTop [= setting]
- textframe.Orientation [= msoTextOrientation]
- textframe.VerticalAlignment [= xlVAlign]
-
18.20. TextEffectFormat
- shape.Alignment [= msoTextEffectAlignment]
- shape.FontBold [= setting]
- shape.FontItalic [= setting]
- shape.FontName [= setting]
- shape.FontSize [= setting]
- shape.KernedPairs [= setting]
- shape.NormalizedHeight [= setting]
- shape.PresetShape [= msoPresetTextEffectShape]
- shape.PresetTextEffect [= msoPresetTextEffect]
- shape.RotatedChars [= setting]
- shape.Text [= setting]
- shape.ToggleVerticalText( )
- shape.Tracking [= setting]
- 18.21. ThreeDFormat
-
19. Adding Menus and Toolbars
- 19.1. About Excel Menus
- 19.2. Build a Top-Level Menu
- 19.3. Create a Menu in Code
- 19.4. Build Context Menus
- 19.5. Build a Toolbar
- 19.6. Create Toolbars in Code
-
19.7. CommandBar and CommandBars Members
- commandbars.ActionControl
- commandbars.ActiveMenuBar
- commandbars.AdaptiveMenus [= setting]
- commandbars.Add([Name], [Position], [MenuBar], [Temporary])
- commandbar.BuiltIn
- commandbar.Controls
- commandbar.Delete( )
- commandbars.DisableAskAQuestionDropdown [= setting]
- commandbars.DisableCustomize [= setting]
- commandbars.DisplayFonts [= setting]
- commandbar.DisplayKeysInTooltips [= setting]
- commandbars.DisplayTooltips [= setting]
- commandbar.Enabled [= setting]
- commandbar.FindControl([Type], [Id], [Tag], [Visible], [Recursive])
- commandbars.FindControls([Type], [Id], [Tag], [Visible])
- commandbar.Id
- commandbars.LargeButtons [= setting]
- commandbars.MenuAnimationStyle [= msoMenuAnimation]
- commandbar.Name [= setting]
- commandbar.NameLocal [= setting]
- commandbar.Position [= msoBarPosition]
- commandbar.Protection [= msoBarProtection]
- CommandBars.ReleaseFocus( )
- commandbar.Reset( )
- commandbar.RowIndex [= msoBarRow]
- commandbar.ShowPopup([x], [y])
- commandbar.Type
-
19.8. CommandBarControl and CommandBarControls Members
- commandbarcontrols.Add([Type], [Id], [Parameter], [Before], [Temporary])
- commandbarcontrol.BeginGroup [= setting]
- commandbarcontrol.BuiltIn
- commandbarcontrol.Caption [= setting]
- commandbarcontrol.Copy([Bar], [Before])
- commandbarcontrol.Delete([Temporary])
- commandbarcontrol.DescriptionText [= setting]
- commandbarcontrol.Enabled [= setting]
- commandbarcontrol.Execute( )
- commandbarcontrol.HelpContextId [= setting]
- commandbarcontrol.HelpFile [= setting]
- commandbarcontrol.Id
- commandbarcontrol.IsPriorityDropped
- commandbarcontrol.Move([Bar], [Before])
- commandbarcontrol.OLEUsage [= msoControlOLEUsage]
- commandbarcontrol.OnAction [= setting]
- commandbarcontrol.Parameter [= setting]
- commandbarcontrol.Priority [= setting]
- commandbarcontrol.Reset( )
- commandbarcontrol.SetFocus( )
- commandbarcontrol.Tag [= setting]
- commandbarcontrol.TooltipText [= setting]
- commandbarcontrol.Type
-
19.9. CommandBarButton Members
- commandbarbutton.CopyFace( )
- commandbarbutton.FaceId [= setting]
- commandbarbutton.HyperlinkType [= msoCommandBarButtonHyperlinkType]
- commandbarbutton.Mask
- commandbarbutton.PasteFace( )
- commandbarbutton.Picture
- commandbarbutton.ShortcutText [= setting]
- commandbarbutton.State [= msoButtonState]
- commandbarbutton.Style [= msoButtonStyle]
-
19.10. CommandBarComboBox Members
- commandbarcombobox.AddItem(Text, [Index])
- commandbarcombobox.Clear( )
- commandbarcombobox.DropDownLines [= setting]
- commandbarcombobox.DropDownWidth [= setting]
- commandbarcombobox.List(Index)
- commandbarcombobox.ListCount
- commandbarcombobox.ListHeaderCount [= setting]
- commandbarcombobox.ListIndex [= setting]
- commandbarcombobox.RemoveItem(Index)
- commandbarcombobox.Style [= msoComboStyle]
- commandbarcombobox.Text [= setting]
- 19.11. CommandBarPopup Members
-
20. Building Dialog Boxes
- 20.1. Types of Dialogs
- 20.2. Create Data-Entry Forms
- 20.3. Design Your Own Forms
- 20.4. Use Controls on Worksheets
-
20.5. UserForm and Frame Members
- form.ActiveControl
- form.BackColor [= rgb]
- form.BorderColor [= rgb]
- form.BorderStyle [= fmBorderStyle]
- form.CanPaste
- form.CanRedo
- form.CanUndo
- form.Caption [= setting]
- form.Controls
- form.Copy( )
- form.Cut( )
- form.Cycle [= fmCycle]
- form.DrawBuffer [= setting]
- form.Enabled [= setting]
- form.Font [= setting]
- form.ForeColor [= rgb]
- form.InsideHeight
- form.InsideWidth
- form.KeepScrollBarsVisible [= fmScrollBars]
- form.MouseIcon [= setting]
- form.MousePointer [= fmMousePointer]
- form.Paste( )
- form.Picture [= setting]
- form.PictureAlignment [= fmPictureAlignment]
- form.PictureSizeMode [= fmPictureSizeMode]
- form.PictureTiling [= setting]
- form.PrintForm
- form.RedoAction( )
- form.Repaint( )
- form.Scroll([ActionX] [, ActionY])
- form.ScrollBars [= fmScrollBars]
- form.ScrollHeight [= setting]
- form.ScrollLeft [= setting]
- form.ScrollTop [= setting]
- form.ScrollWidth [= setting]
- form.SetDefaultTabOrder( )
- form.SpecialEffect [= fmButtonEffect]
- form.UndoAction( )
- form.VerticalScrollBarSide [= fmVerticalScrollbarSide]
- form.Zoom [= setting]
-
20.6. Control and Controls Members
- controls.Add(ProgID [, Name] [, Visible])
- control.Cancel [= setting]
- controls .Clear( )
- control.ControlSource [= setting]
- control.ControlTipText [= setting]
- control.Default [= setting]
- control.LayoutEffect
- controls.Move ([Left ][, Top ][, Width ][, Height ][, Layout])
- control.Object
- control.OldHeight
- control.OldLeft
- control.OldTop
- control.OldWidth
- control.Remove(Index)
- control.RowSource [= setting]
- control.SetFocus( )
- control.TabIndex [= setting]
- control.TabStop [= setting]
- control.Tag [= setting]
- control.ZOrder([zPosition])
- 20.7. Font Members
- 20.8. CheckBox, OptionButton, ToggleButton Members
-
20.9. ComboBox Members
- control.AddItem(Item[, Index])
- control.AutoTab [= setting]
- control.AutoWordSelect [= setting]
- control.BoundColumn [= setting]
- control.Clear( )
- control.Column([Column][, Row])
- control.ColumnCount [= setting]
- control.ColumnHeads [= setting]
- control.ColumnWidths [= setting]
- control.CurTargetX
- control.CurX [= setting]
- control.DragBehavior [= fmDragBehavior]
- control.DropButtonStyle [= fmDropButtonStyle]
- control.DropDown( )
- control.EnterFieldBehavior [= fmEnterFieldBehavior]
- control.HideSelection [= setting]
- control.IMEMode [= fmIMEMode]
- control.LineCount
- control.List([Row, Column]) [= setting]
- control.ListCount
- control.ListIndex [= setting]
- control.ListRows [= setting]
- control.ListStyle [= fmListStyle]
- control.ListWidth [= setting]
- control.MatchEntry [= fmMatchEntry]
- control.MatchFound
- control.MatchRequired [= setting]
- control.MaxLength [= setting]
- control.RemoveItem(Index)
- control.SelectionMargin [= setting]
- control.SelLength [= setting]
- control.SelStart [= setting]
- control.SelText [= setting]
- control.ShowDropButtonWhen [= fmShowDropButtonWhen]
- control.Style [= fmStyle]
- control.Text [= setting]
- control.TextAlign [= fmTextAlign]
- control.TextColumn [= setting]
- control.TextLength
- control.TopIndex [= setting]
- 20.10. CommandButton Members
- 20.11. Image Members
- 20.12. Label Members
- 20.13. ListBox Members
- 20.14. MultiPage Members
- 20.15. Page Members
- 20.16. ScrollBar and SpinButton Members
- 20.17. TabStrip Members
- 20.18. TextBox and RefEdit Members
-
21. Sending and Receiving Workbooks
- 21.1. Send Mail
- 21.2. Work with Mail Items
- 21.3. Collect Review Comments
- 21.4. Route Workbooks
- 21.5. Read Mail
- 21.6. MsoEnvelope Members
-
21.7. MailItem Members
- mailitem.Attachments
- mailitem.BCC [= setting]
- mailitem.Body [= setting]
- mailitem.CC [= setting]
- mailitem.Close(SaveMode)
- mailitem.DeferredDeliveryTime [= setting]
- mailitem.DeleteAfterSubmit [= setting]
- mailitem.Display( )
- mailitem.ExpiryTime [= setting]
- mailitem.HTMLBody [= setting]
- mailitem.Importance [= setting]
- mailitem.PrintOut( )
- mailitem.ReadReceiptRequested [= setting]
- mailitem.Recipients
- mailitem.Save( )
- mailitem.SaveAs(Path, Type)
- mailitem.SaveSentMessageFolder [= setting]
- mailitem.Send( )
- mailitem.SenderEmailAddress
- mailitem.SenderName
- mailitem.Sensitivity [= olSensitivity]
- mailitem.Subject [= setting]
- mailitem.To [= setting]
- 21.8. RoutingSlip Members
-
7. Controlling Excel
-
III. Extending Excel
- 22. Building Add-ins
- 23. Integrating DLLs and COM
-
24. Getting Data from the Web
- 24.1. Perform Web Queries
-
24.2. QueryTable and QueryTables Web Query Members
- querytables.Add(Connection, Destination, [Sql])
- querytable.AdjustColumnWidth [= setting]
- querytable.BackgroundQuery [= setting]
- querytable.CancelRefresh
- querytable.Connection [= setting]
- querytable.Delete
- querytable.Destination
- querytable.EditWebPage [= setting]
- querytable.EnableEditing [= setting]
- querytable.EnableRefresh [= setting]
- querytable.FetchedRowOverflow
- querytable.FillAdjacentFormulas [= setting]
- querytable.PostText [= setting]
- querytable.PreserveFormatting [= setting]
- querytable.QueryType [= xlQueryType]
- querytable.Refresh([BackgroundQuery])
- querytable.Refreshing
- querytable.RefreshOnFileOpen [= setting]
- querytable.RefreshPeriod [= setting]
- querytable.RefreshStyle [= xlCellInsertionMode]
- querytable.ResetTimer
- querytable.ResultRange
- querytable.TablesOnlyFromHTML [= setting]
- querytable.WebConsecutiveDelimitersAsOne [= setting]
- querytable.WebDisableDateRecognition [= setting]
- querytable.WebDisableRedirections [= setting]
- querytable.WebFormatting [= setting]
- querytable.WebPreFormattedTextToColumns [= setting]
- querytable.WebSelectionType [= xlWebSelectionType]
- querytable.WebSingleBlockTextImport [= setting]
- querytable.WebTables [= setting]
- 24.3. Use Web Services
- 24.4. Resources
-
25. Programming Excel with .NET
- 25.1. Approaches to Working with .NET
- 25.2. Create .NET Components for Excel
- 25.3. Use .NET Components in Excel
- 25.4. Use Excel as a Component in .NET
- 25.5. Create Excel Applications in .NET
- 25.6. Resources
-
26. Exploring Security in Depth
- 26.1. Security Layers
- 26.2. Understand Windows Security
- 26.3. Password-Protect and Encrypt Workbooks
- 26.4. Program with Passwords and Encryption
-
26.5. Workbook Password and Encryption Members
- workbook.HasPassword
- workbook.Password [= setting]
- workbook.PasswordEncryptionAlgorithm
- workbook.PasswordEncryptionFileProperties
- workbook.PasswordEncryptionKeyLength
- workbook.PasswordEncryptionProvider
- workbook.SetPasswordEncryptionOptions(PasswordEncryptionProvider, PasswordEncryptionAlgorithm, PasswordEncryptionKeyLength, PasswordEncryptionFileProperties)
- workbook.WritePassword [= setting]
- workbook.WriteReserved
- workbook.WriteReservedBy
- 26.6. Excel Password Security
- 26.7. Protect Items in a Workbook
- 26.8. Program with Protection
-
26.9. Workbook Protection Members
- workbook.Protect([Password], [Structure], [Windows])
- workbook.ProtectSharing([Filename], [Password], [WriteResPassword], [ReadOnlyRecommended], [CreateBackup], [SharingPassword])
- workbook.ProtectStructure
- workbook.ProtectWindows
- workbook.Unprotect([Password])
- workbook.UnprotectSharing([SharingPassword])
-
26.10. Worksheet Protection Members
- worksheet.Protect([Password], [DrawingObjects], [Contents], [Scenarios], [UserInterfaceOnly], [AllowFormattingCells], [AllowFormattingColumns], [AllowFormattingRows], [AllowInsertingColumns], [AllowInsertingRows], [AllowInsertingHyperlinks], [AllowDeletingColumns], [AllowDeletingRows], [AllowSorting], [AllowFiltering], [AllowUsingPivotTables])
- worksheet.ProtectContents
- worksheet.ProtectDrawingObjects
- worksheet.Protection
- worksheet.ProtectionMode
- worksheet.ProtectScenarios
- worksheet.Unprotect([Password])
- 26.11. Chart Protection Members
-
26.12. Protection Members
- protection.AllowDeletingColumns
- protection.AllowDeletingRows
- protection.AllowEditRanges
- protection.AllowFiltering
- protection.AllowFormattingCells
- protection.AllowFormattingColumns
- protection.AllowFormattingRows
- protection.AllowInsertingColumns
- protection.AllowInsertingHyperlinks
- protection.AllowInsertingRows
- protection.AllowSorting
- protection.AllowUsingPivotTables
- 26.13. AllowEditRange and AllowEditRanges Members
- 26.14. UserAccess and UserAccessList Members
- 26.15. Set Workbook Permissions
- 26.16. Program with Permissions
-
26.17. Permission and UserPermission Members
- permission.Add(UserId, [Permission], [ExpirationDate])
- permission.ApplyPolicy(FileName)
- permission.DocumentAuthor [= setting]
- permission.Enabled [= setting]
- permission.EnableTrustedBrowser [= setting]
- userpermission.ExpirationDate [= setting]
- userpermission.Permission [= setting]
- permission.PermissionFromPolicy
- permission.PolicyDescription
- permission.PolicyName
- userpermission.Remove( )
- permission.RemoveAll( )
- permission.RequestPermissionURL [= setting]
- permission.StoreLicenses [= setting]
- userpermission.UserId
- 26.18. Add Digital Signatures
- 26.19. Set Macro Security
- 26.20. Set ActiveX Control Security
- 26.21. Distribute Security Settings
- 26.22. Using the Anti-Virus API
- 26.23. Common Tasks
- 26.24. Resources
- IV. Appendixes
- About the Authors
- Colophon
- Copyright
Product information
- Title: Programming Excel with VBA and .NET
- Author(s):
- Release date: April 2006
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9780596007669
You might also like
book
Excel VBA Programming For Dummies
Take your data analysis and Excel programming skills to new heights In order to take Excel …
book
Excel 2019 Power Programming with VBA
Maximize your Excel experience with VBA Excel 2019 Power Programming with VBA is fully updated to …
book
Excel VBA Programming For Dummies, 5th Edition
Take your Excel programming skills to the next level To take Excel to the next level, …
book
Programming Excel with VBA: A Practical Real-World Guide
Learn to harness the power of Visual Basic for Applications (VBA) in Microsoft Excel to develop …