-
Import from Excel to PPT MasterSlide VBA works in SldShow, but NOT appear until exit
As an educator, I use PPT for class. I want a list of names to drop down on any slide of a multi-slide PPT, so using MasterSlide(1)Layout(4). Slide space is limited and I have similar dropdowns on normal slides already using the
same basic method which works in Slide Show Mode.
The problem (or, PPT limitation) is this works, but NOT without exiting the Slideshow and re-starting. Most useful
to my situation is to have the list appear while continuing in SlideShow. Code:
Sub ImportNames()
Dim xlsWB As Object
Set xlsWB = CreateObject("Excel.Application").Workbooks.Open(ActivePresentation.Path & "\StretchW59JH381.xlsx")
ActivePresentation.Designs(1).SlideMaster.Shapes("T_1").TextFrame.TextRange = xlsWB.Worksheets(1).Range("B3")
Set xlsWB = Nothing
End Sub
Any solution or concrete answer would be much appreciated!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules