I was wondering if anyone has a solution for importing SharePoint list data into a PowerPoint document. For instance, if I create a document library and set the default document type to "Word document", I can use "Quick Parts" to link the template to SharePoint list fields.

I'd like to use a similar technique for PowerPoint.


You will have to save the presentation as a Macro-Enabled Presentation (.pptm) and then save it to your SharePoint list. Once there, add code along the lines below to whatever event/button fits your needs

ActivePresentation.Slides(1).Shapes(1).TextFrame.TextRange.Text = ActivePresentation.ContentTypeProperties("MyCustom").Value

This will update the text of the first element on the first slide (usually the presentation title) and set it to the value of the field "MyCustom" that is from the SharePoint list.

It will take some playing around to get it working but you should be able to get there.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.