O Microsoft Office 2010 tem as ferramentas necessárias para criar aplicativos poderosos. As aplicações abaixo, desenvolvidas com o Visual Basic for Applications (VBA), são amostras de códigos que podem ajudá-lo a criar seus próprios aplicativos que executam funções específicas ou servirem como ponto de partida para criar soluções mais complexas.
Cada amostra de código a seguir é composta de aproximadamente 5 a 50 linhas de código. Cada amostra inclui comentários descrevendo o código para que possa executá-los com os resultados esperados e os comentários explicarão como configurar o ambiente para que o código de exemplo seja executado.
Baixe todos os códigos em um único arquivo zip, ou clique em cada título individual para baixar o código VBA:
Excel 2010
- Excel 2010: Add Icon Sets for Ranges Using Excel.AddIconSetCondition
- Excel 2010: Apply Conditional Formatting Using the Excel.DataBar Method
- Excel 2010: Change Colors to Indicate Values Above and Below Average in Ranges
- Excel 2010: Communicate with PageSetup Using the Excel.PrintCommunication Method
- Excel 2010: Create and Manipulate Custom Views Using Excel.CustomView Method
- Excel 2010: Create Charts Events Programmatically
- Excel 2010: Determine Open Add-Ins Using Excel.TestAddIn.IsOpen
- Excel 2010: Display Top Ten Percent in Ranges Programmatically
- Excel 2010: Display Unique Numbers in Ranges Using Excel.AddUnique
- Excel 2010: Enable Removal of Duplicate Rows Using Excel.RemoveDuplicates
- Excel 2010: Export Data to PDF or XPS Using the Excel.ExportAsFixedFormat Method
- Excel 2010: Format Data Ranges Using the Excel.DisplayFormat Method
- Excel 2010: Formatting Colors in Ranges Using Excel.AddColorScale
- Excel 2010: Manipulate UI Properties Using Excel.ApplicationProperties
- Excel 2010: Modify Display Properties of Tables Using Excel.ListObjectDisplay
- Excel 2010: Remove Various Properties Using Excel.RemoveDocumentInformation
- Excel 2010: Retrieve Information About Chart Points Using Excel.PointClass
- Excel 2010: Show Properties of Chart Series Using Excel.SeriesProperties
- Excel 2010: Show Properties of Exceeded Frames Using Excel.TextFrameProperties
- Excel 2010: Show Properties of ListObject Using Excel.ListObjectTableStyles
- Excel 2010: Show Properties of the Window Object Using Excel.WindowProperties
- Excel 2010: Sort and Filter Programmatically Using Excel.ListObjectSortFilter
- Excel 2010: Sort Data Programmatically Using Excel.WorksheetSort
- Excel 2010: Use Properties of Sparkline Groups Using Excel.SparkLines
- Excel 2010: Work with DataBodyRange and Total Properties Using Excel.ListColumn
- Excel 2010: Work with Gradient Fill Features Using Excel.Gradient Method
- Excel 2010: Work with Header and Footer Properties Using Excel.PagesAndPage
- Excel 2010: Work with Hyperlinks Programmatically
- Excel 2010: Work with Several Date Functions Using Excel.WorksheetFunctionDates
- Excel 2010: Work with Various Properties Using Excel.PageSetup Object
Office 2010
- Office 2010: Change Chart Layouts Using Office.Chart.ModifyChartLayout
- Office 2010: Create Bar Charts Using Office.Chart.CreateSimpleChart
- Office 2010: Modify Chart Axis Text Using Office.Chart.WorkWithAxisText
- Office 2010: Modify Chart Legends Using Office.Chart.WorkWithLegend
- Office 2010: Modify Chart Titles Using Office.Chart.WorkWithTitle
- Office 2010: Modify Charts Using Office.Chart.ModifyChartData
OneNote 2010
- OneNote 2010: Create New Pages Programmatically Using OneNote.CreateOneNotePage
- OneNote 2010: Manipulate Docking Using OneNote.fromVBA.DockWindow
- OneNote 2010: Navigate to Objects in OneNote 2010 Using OneNote.NavigateTo
- OneNote 2010: Open, Close, and Display OneNote 2010 Notebooks in a New Window
- OneNote 2010: Output OneNote 2010 Page Content from VBA Sources
- OneNote 2010: Output OneNote 2010 Page Content to PDF Files
- OneNote 2010: Perform Keyword Searches in OneNote and Get Results in XML Format
- OneNote 2010: Retrieve Attribute Data About Sections in OneNote 2010 Notebooks
- OneNote 2010: Retrieve Data About Notebooks Using OneNote.fromVBA.ListNotebooks
- OneNote 2010: Retrieve Information About Open OneNote 2010 Windows
- OneNote 2010: Retrieve Metadata From Pages of OneNote 2010 Notebook Sections
- OneNote 2010: Return Backup Folder Data Locations Using GetSpecialLocation
- OneNote 2010: Work with Built-In Dialogs and Properties Using QuickFiling Dialog
Outlook 2010
- Outlook 2010: Access Lists of SharePoint Objects Using Outlook.PickerDialog
- Outlook 2010: Create SMS and MMS Messages Using Outlook.MobileItem
- Outlook 2010: Manipulate Items in Mail Conversations Using Outlook.Conversations
- Outlook 2010: View Exchange Server Properties Using Outlook.ExchangeAccounts
PowerPoint 2010
- PowerPoint 2010: Add and Format Shapes Using PPT.ColorFormat.Brightness
- PowerPoint 2010: Add Series of Application-Level Events Using PPT.NewEvents
- PowerPoint 2010: Apply Themes & Backgrounds Using PPT.ApplyTheme.BackgroundStyle
- PowerPoint 2010: Change Chart Locations Using PPT.InteractWithChartLocation
- PowerPoint 2010: Control Animation Click Behavior Using PPT.SlideShowClicks
- PowerPoint 2010: Convert Text into SmartArt Using PPT.ConvertTextToSmartArt
- PowerPoint 2010: Copy Animation Using PPT.PickupAndApplyAnimation
- PowerPoint 2010: Create Videos Programmatically
- PowerPoint 2010: Display Media Control Properties
- PowerPoint 2010: Export Slides as PPTX Files Using PPT.PublishSlides
- PowerPoint 2010: Insert, Move, Get Section Counts Using PPT.WorkWithSections
- PowerPoint 2010: Interact with Table Styles Using PPT.Table.ApplyStyle
- PowerPoint 2010: Link Videos and Embedded Audio Files Using PPT.AddMedia
- PowerPoint 2010: List SmartArt Names Using PPT.WorkWithSmartArt
- PowerPoint 2010: Merge Two Decks into One Using PPT.MergeWithBaseline
- PowerPoint 2010: Modify Aspects of Videos Using PPT.MediaFormatProperties
- PowerPoint 2010: Resample and Reset Resolution Using PPT.ResampleMedia
- PowerPoint 2010: Set Background Fill in Tables Using PPT.TableBackground
- PowerPoint 2010: Set Banding and Scaling of Tables Using PPT.TableProperties
- PowerPoint 2010: Use Custom XML Data Using PPT.CustomerDataDemo
- PowerPoint 2010: View Properties of ShadowFormat Class Using PPT.Shadow
- PowerPoint 2010: Work with FillFormat Texture Settings Using PPT.ShapeTexture
- PowerPoint 2010: Work with Methods of Player Class Using PPT.WorkWithMediaPlayer
- PowerPoint 2010: Work with Shape Glow and Reflection Properties
Visio 2010
- Visio 2010: Add Containers and Connect Shapes in Visio 2010 Documents
- Visio 2010: Add Containers to Visio Documents Using Visio.ContainerProperties
- Visio 2010: Bind Two Shapes Together Using Visio.Page.DropCallout
- Visio 2010: Manipulate Connected Shapes Using Visio.Page.DropConnected
- Visio 2010: Manipulate Raster Export Resolution Settings
- Visio 2010: Manipulate Shape Properties Using Visio.DropContainer
- Visio 2010: Read and Write Raster Export Resolution Settings
Word 2010
- Word 2010: Add Application-Level Events Using Word.New Application Events
- Word 2010: Add Glow and Reflection Effects to Text
- Word 2010: Add Picture Shapes and Format Cropping Using Word.PictureFormat.Crop
- Word 2010: Apply a Quick Style Set Using Word.QuickStyleSets
- Word 2010: Apply Themes and Styles Using Word.DocumentApplyThemeQuickStyle
- Word 2010: Check-In Word 2010 Documents with Versioning on SharePoint Servers
- Word 2010: Clear Formatting Using Word.SelectionClearFormatting
- Word 2010: Compare Features of Two Documents Using Word.DemoCompareDocuments
- Word 2010: Create a New Quick Style Set Using Word.SaveAsQuickStyleSet
- Word 2010: Export and Import Text Fragments Using Word.RangeImportExportFragment
- Word 2010: Ignore Punctuation, Match Prefixes and Suffixes, Clear Highlighting
- Word 2010: List Combo Box Content Information Using Word.ContentControlLists
- Word 2010: Make and Save Edits Concurrently Using Word.Coauthoring
- Word 2010: Manipulate Check Box Controls Using Word.CheckBoxContentControl
- Word 2010: Rotate and Warp Text Using Word.WorkWithTextFrame
- Word 2010: Work with Auto-Hyphenation Using Word.ConvertAutoHyphens
- Word 2010: Work with Nested Undo Records Using Word.NestedCustomUndoRecords
- Word 2010: Work with Properties of Range Object Using Word.CharParagraphStyle
- Word 2010: Work with the Undo Stack Using Word.CustomUndoRecord
- Word 2010: Work with Themes, Track Formatting, Track Revisions, and Track Moves
Referências: MSDN
Tags: VBA, Office, Office 2010, MSDN, MSDN Library, Microsoft, solutions, tools, applications, developer, Microsoft Office 2010, technology
