EJEMPLS VBA

101 VBA samples for Office 2010

Microsoft Office 2010 gives you the tools needed to create powerful applications. These Visual Basic for Applications (VBA) code samples can assist you in creating your own applications that perform specific functions or as a starting point to create more complex solutions.

Each code sample consists of approximately 5 to 50 lines of code demonstrating a distinct feature or feature set in VBA. Each sample includes comments describing the sample, and setup code so that you can run the code with expected results or the comments will explain how to set up the environment so that the sample code runs.

---

Office 2010 101 Code Samples.zip Download all samples in a single zip file, or click each title below to download the VBA code for that specific snippet.

---

Excel 2010 Add Icon Sets for Ranges Using Excel.AddIconSetCondition Apply Conditional Formatting Using the Excel.DataBar Method Change Colors to Indicate Values Above and Below Average in Ranges Communicate with PageSetup Using the Excel.PrintCommunication Method Create and Manipulate Custom Views Using Excel.CustomView Method Create Charts Events Programmatically Determine Open Add-Ins Using Excel.TestAddIn.IsOpen Display Top Ten Percent in Ranges Programmatically Display Unique Numbers in Ranges Using Excel.AddUnique Enable Removal of Duplicate Rows Using Excel.RemoveDuplicates Export Data to PDF or XPS Using the Excel.ExportAsFixedFormat Method Format Data Ranges Using the Excel.DisplayFormat Method Formatting Colors in Ranges Using Excel.AddColorScale Manipulate UI Properties Using Excel.ApplicationProperties Modify Display Properties of Tables Using Excel.ListObjectDisplay Remove Various Properties Using Excel.RemoveDocumentInformation Retrieve Information About Chart Points Using Excel.PointClass Show Properties of Chart Series Using Excel.SeriesProperties Show Properties of Exceeded Frames Using Excel.TextFrameProperties Show Properties of ListObject Using Excel.ListObjectTableStyles Show Properties of the Window Object Using Excel.WindowProperties Sort and Filter Programmatically Using Excel.ListObjectSortFilter Sort Data Programmatically Using Excel.WorksheetSort Use Properties of Sparkline Groups Using Excel.SparkLines Work with DataBodyRange and Total Properties Using Excel.ListColumn Work with Gradient Fill Features Using Excel.Gradient Method Work with Header and Footer Properties Using Excel.PagesAndPage Work with Hyperlinks Programmatically Work with Several Date Functions Using Excel.WorksheetFunctionDates Work with Various Properties Using Excel.PageSetup Object Office 2010 Change Chart Layouts Using Office.Chart.ModifyChartLayout Create Bar Charts Using Office.Chart.CreateSimpleChart Modify Chart Axis Text Using Office.Chart.WorkWithAxisText Modify Chart Legends Using Office.Chart.WorkWithLegend Modify Chart Titles Using Office.Chart.WorkWithTitle Modify Charts Using Office.Chart.ModifyChartData OneNote 2010 Create New Pages Programmatically Using OneNote.CreateOneNotePage Manipulate Docking Using OneNote.fromVBA.DockWindow Navigate to Objects in OneNote 2010 Using OneNote.NavigateTo Open, Close, and Display OneNote 2010 Notebooks in a New Window Output OneNote 2010 Page Content from VBA Sources Output OneNote 2010 Page Content to PDF Files Perform Keyword Searches in OneNote and Get Results in XML Format Retrieve Attribute Data About Sections in OneNote 2010 Notebooks Retrieve Data About Notebooks Using OneNote.fromVBA.ListNotebooks Retrieve Information About Open OneNote 2010 Windows Retrieve Metadata From Pages of OneNote 2010 Notebook Sections Return Backup Folder Data Locations Using GetSpecialLocation Work with Built-In Dialogs and Properties Using QuickFiling Dialog Outlook 2010 Access Lists of SharePoint Objects Using Outlook.PickerDialog Create SMS and MMS Messages Using Outlook.MobileItem Manipulate Items in Mail Conversations Using Outlook.Conversations View Exchange Server Properties Using Outlook.ExchangeAccounts

PowerPoint 2010 Add and Format Shapes Using PPT.ColorFormat.Brightness Add Series of Application-Level Events Using PPT.NewEvents Apply Themes & Backgrounds Using PPT.ApplyTheme.BackgroundStyle Change Chart Locations Using PPT.InteractWithChartLocation Control Animation Click Behavior Using PPT.SlideShowClicks Convert Text into SmartArt Using PPT.ConvertTextToSmartArt Copy Animation Using PPT.PickupAndApplyAnimation Create Videos Programmatically Display Media Control Properties Export Slides as PPTX Files Using PPT.PublishSlides Insert, Move, Get Section Counts Using PPT.WorkWithSections Interact with Table Styles Using PPT.Table.ApplyStyle Link Videos and Embedded Audio Files Using PPT.AddMedia List SmartArt Names Using PPT.WorkWithSmartArt Merge Two Decks into One Using PPT.MergeWithBaseline Modify Aspects of Videos Using PPT.MediaFormatProperties Resample and Reset Resolution Using PPT.ResampleMedia Set Background Fill in Tables Using PPT.TableBackground Set Banding and Scaling of Tables Using PPT.TableProperties Use Custom XML Data Using PPT.CustomerDataDemo View Properties of ShadowFormat Class Using PPT.Shadow Work with FillFormat Texture Settings Using PPT.ShapeTexture Work with Methods of Player Class Using PPT.WorkWithMediaPlayer Work with Shape Glow and Reflection Properties Visio 2010 Add Containers and Connect Shapes in Visio 2010 Documents Add Containers to Visio Documents Using Visio.ContainerProperties Bind Two Shapes Together Using Visio.Page.DropCallout Manipulate Connected Shapes Using Visio.Page.DropConnected Manipulate Raster Export Resolution Settings Manipulate Shape Properties Using Visio.DropContainer Read and Write Raster Export Resolution Settings Word 2010 Add Application-Level Events Using Word.New Application Events Add Glow and Reflection Effects to Text Add Picture Shapes and Format Cropping Using Word.PictureFormat.Crop Apply a Quick Style Set Using Word.QuickStyleSets Apply Themes and Styles Using Word.DocumentApplyThemeQuickStyle Check-In Word 2010 Documents with Versioning on SharePoint Servers Clear Formatting Using Word.SelectionClearFormatting Compare Features of Two Documents Using Word.DemoCompareDocuments Create a New Quick Style Set Using Word.SaveAsQuickStyleSet Export and Import Text Fragments Using Word.RangeImportExportFragment Ignore Punctuation, Match Prefixes and Suffixes, Clear Highlighting List Combo Box Content Information Using Word.ContentControlLists Make and Save Edits Concurrently Using Word.Coauthoring Manipulate Check Box Controls Using Word.CheckBoxContentControl Rotate and Warp Text Using Word.WorkWithTextFrame Work with Auto-Hyphenation Using Word.ConvertAutoHyphens Work with Nested Undo Records Using Word.NestedCustomUndoRecords Work with Properties of Range Object Using Word.CharParagraphStyle Work with the Undo Stack Using Word.CustomUndoRecord Work with Themes, Track Formatting, Track Revisions, and Track Moves