Reorder Powerpoint slides from Excel with VBA

[tiredofit]

In Excel, it is possible to refer to a worksheet by its name, codename or index.

For Powerpoint, I know it's possible to refer to a slide by its index but does each slide also have a name property and if so, can it be changed?

My ultimate objective is to use VBA in EXCEL to reorder the slides in POWERPOINT.

Say I have 5 slides, A, B, C, D, E.

I want to swap A and B round, so the new order needs to be B, A C, D, E.

Is it possible and if so, how might I go about it?

Thanks

 

[Trevor G]

Take a look at this link it may help. Do you know the code to control PowerPoint. I.e. open PowerPoint as an application and then open a presentation?

Slide.MoveTo method (PowerPoint)

Office VBA reference topic

learn.microsoft.com

 

[tiredofit]

Take a look at this link it may help. Do you know the code to control PowerPoint. I.e. open PowerPoint as an application and then open a presentation?

Slide.MoveTo method (PowerPoint)

Office VBA reference topic

learn.microsoft.com

I assume you're refering to this?

Sub MoveSlideToNewLocation()    ActivePresentation.Slides(2).MoveTo toPos:=1End Sub

That identifies by Index, not SlideID.


"Do you know the code to control PowerPoint. I.e. open PowerPoint as an application and then open a presentation?"

Yes I can open pptx from Excel.

 

[Trevor G]

Yes that's what's suggested.

You could give each slide a title and use the title or refer to the slideid. See if this link helps.

Sort a presentation based on slide titles

From the PowerPoint FAQ: Sort a presentation based on slide titles

www.rdpslides.com

 

[tiredofit]

Yes that's what's suggested.

You could give each slide a title and use the title or refer to the slideid. See if this link helps.

Sort a presentation based on slide titles

From the PowerPoint FAQ: Sort a presentation based on slide titles

www.rdpslides.com

Thanks, I'll try that approach.