UPDATE: I have updated the code in this article so you do not need to do this step, however intellisense for any PowerPoint objects in the Visual Basic Editor will not work. In the below image I show you exactly how to do this and prove afterwards that Excel now knows PowerPoint lingo! Then make sure the reference Microsoft Office PowerPoint 12.0 Object Library is checked (the version number may verify, for example in Office 2016 the reference would be Office PowerPoint 16.0 Object Library). In order to activate PowerPoint's object library, simply click the Tools menu in the Visual Basic Editor and select Reference. You can learn more about this topic by reading my post Teaching Excel To Speak PowerPoint. PowerPoint uses a vocabulary containing terms such as "Slide" and "Presentation" that simply do not exist in Excel's own code language. In order to control PowerPoint from inside Excel's Visual Basic Editor, we need to teach Excel how to speak in PowerPoint's terms. DataType:=2 '2 = ppPasteEnhancedMetafile Set mySlide = (1, 11) '11 = ppLayoutTitleOnly MsgBox "PowerPoint could not be found, aborting." 'Handle if the PowerPoint Application is not found If PowerPointApp Is Nothing Then Set PowerPointApp = CreateObject(class:="PowerPoint.Application") 'If PowerPoint is not already open then open PowerPoint Set PowerPointApp = GetObject(class:="PowerPoint.Application") manual copy&paste and VBA coding).'PURPOSE: Copy/Paste An Excel Range Into a New PowerPoint Presentation Basically, SlideFab 2 disrupts the classical way how slide mass-production has been made for decades (i.e. It contains numerous features out of the box which are for most coders unreachable in the given time frame. As a result, SlideFab empowers users to create a slide mass production within minutes. It did the job perfectly but it was way too complicated.īased on user feedback, process redesign and modern UX concepts the all-new SlideFab 2 was built from scratch. knowing what a VLookup is) should be able to create an Excel-based slide-making automation. So, during this project the idea came up that automation has to be simplified.Ĭonsequently, t he ambition was that everybody with decent Excel skills (i.e. Others write macros which are not really maintainable and often create more overhead then help. Not surprisingly, most people handle such situations by rigorously applying copy&paste. Whenever new data was incorporated into the Excel workbook, all PowerPoint slides for the management had to be updated. SlideFab was invented during a project where 20 scenarios – each having different constraints – were analyzed. SlideFab was invented because copy/paste or one-off VBA macros were just a waste of time
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |