Wow...thank you Andrew and WiseOwl for the specific video.. Just a couple of minutes ago, a friend called me asking for videos in WebScrapping through VBA, I suggested your video series on WebSrapping... Your short video series on VBA is simply amazing...You are the best VBA trainer on the earth...keep up the good work sir...Bags of love from India
Hi Mr. Wise Owl! I know that this vid was from 2 years ago but this really helps a lot and with that, I want to say thank you! Also, is there a way or a separate video for looping thru specific cells then pasting it on textboxes in PPT? Thank you again for this Amazing Video!
Or maybe not a loop, like specific cell to specific textbox. Right now I have like.. Set sh = sl. Shapes(2) Range("Cell that I wanted to copy").Copy sh.TextFrame.TextRange.Paste Set sh = sl. Shapes(3) Range("Cell that I wanted to copy").Copy sh.TextFrame.TextRange.Paste And so on...
@@jaaaaayz Hi! There's no convenient way to do this that doesn't involve lots of setup work. The last time I did this for a client I gave each cell that I wanted to copy from a unique range name and then gave the same name to the PowerPoint shape that the cell needed to be copied to. I then looped through the Names collection of the workbook, using the Name property of each Name object to map the cell to a shape. I hope that points you in the right direction!
Do you have any videos explaining how to create a table, say, in the final slide of a presentation that can populate variables throughout the other slides? I can't find ANYTHING on that.
Thank you for the video! New to vba here but is there a way you can refer to the presentation if it is already open on your desktop? I keep getting a runtime error when I try to set pres = ActivePresentation
Hi Stephanie! Yes, if the presentation is already open you can reference it like so: Dim ppt As PowerPoint.Application Dim pres As PowerPoint.Presentation
Set ppt = GetObject(Class:="PowerPoint.Application")
'refer to active presentation Set pres = ppt.ActivePresentation
'refer to named presentation Set pres = ppt.Presentations("Presentation1.pptx") I hope it helps!
Hi Wise Owl! I have an odd thing I'm trying to do, but with no real background in Visual Basic. I'm trying to create a PowerPoint where the text and all formatting from one text box will automatically copy to other text specific boxes on other slides throughout a presentation. For context, this is the "daily schedule" for a museum, and I'm attempting to make the daily schedule auto populate across multiple slides. Thanks in advance for your help regardless!
Hi! It's difficult to provide detailed advice without knowing exactly how your presentation is structured, but if you want to copy an entire text box from one slide to another, this basic code will work: Sub Copy_Text_Box() ActivePresentation.Slides(1).Shapes(1).Copy
ActivePresentation.Slides(2).Shapes.Paste
End Sub If you want to copy the contents of a text box into another existing text box (including the formatting) try something like this instead: Sub Copy_Text_Box_Contents() ActivePresentation.Slides(1).Shapes(1).TextFrame2.TextRange.Copy
Thank you WiseOwl for this video and the way you explain things is amazing and super clear. By the way I did not get one thing, how do I know which is the index of a shape in a existing ppt deck?
Hi Paolo! There isn't a property to return the index of a shape as far as I know. The answers here show a way to loop through the Shapes collection to determine the index number stackoverflow.com/questions/53242865/get-shape-index-in-powerpoint-vba I hope it helps!
Hi Sir. I am regularly following your videos and your explanation is very clear. 100% working I have a requirement there is a table in Excel which is formatted with blue colour header and white colour for table Need to copy this into ppt slide as editable, don't want excel pop-up or other link ..... . Tried in many ways not able to crack it.
Thakyou Andrew!!! Video is very helpful Also can you please let me know how to copy specific charts into specific slides ? It will be very helpful. Thanks in advance
Thank you so much, it is a great video! But what if I want a specific cell value a number for example to be pasted within a paragraph in PPT ? Would really appreciate your help about this!
Hi! docs.microsoft.com/en-us/office/vba/api/powerpoint.textrange Use one of the following methods to return a portion of the text of a TextRange object: Characters, Lines, Paragraphs, Runs, Sentences, or Words. Use one of the following methods to insert characters into a TextRange object:InsertAfter, InsertBefore
Going to use this to lazily relabel power point slide titles so I only need to type in a city's name once into an excel file and everything just goes my way.
Sadly I can not finish the video. After you write your script and press F5 to open your powerpoint presentation, I run into an error. It highlights the 2nd line "ppt As PowerPoint.Application" and says Conpile error: User-defined type not defined. Everything in my script is word-for-word what you typed.
I was literally looking for a video on excel to powerpoint similar object to this. I couldn't find anything useful and then you upload it.. I can't thank you enough. I have a question though, I want to use this method to create complicated and rich quotation. Assuming I have 30-40 boxes in a slide, is there a way to find which box is which other than just trial and error method?
Hi there! You can use the Selection Pane in PowerPoint to see the names of objects on a slide. There are several ways to open the Selection Pane, try Home | Arrange | Selection Pane. You can click an object to find out its name. You can double-click an item in the Selection Pane to rename an object. You can reference the name of the object in VBA for example like this: ActivePresentation.Slides(1).Shapes("Title 1") I hope that helps!
Thank you so much for posting this video! This is amazing! My work requires me to create certificates weekly, with the data (names, date, etc) stored in excel, then the certificate template is in powerpoint. Each week, I need to create between 20 to hundreds of certificates, so you can just imagine how much copy and pasting I do. I was wondering if it is possible to do this copy pasting using this method. Maybe with looping the code until the end of the last data in the excel table? Also, can we add slides based on how many data is in the excel table? If you can point me to some resources about this, that would be awesome too
Hi! We have a few videos on using VBA with PowerPoint which you can find by heading to the WiseOwl channel page and searching for PowerPoint ruclips.net/user/WiseOwlTutorialssearch?query=powerpoint I hope it helps!
Thank you so much Wise Owl. This is going to save a ton of time and effort for my team.
Happy to hear that it helped! Thanks for watching!
Wow...thank you Andrew and WiseOwl for the specific video..
Just a couple of minutes ago, a friend called me asking for videos in WebScrapping through VBA, I suggested your video series on WebSrapping...
Your short video series on VBA is simply amazing...You are the best VBA trainer on the earth...keep up the good work sir...Bags of love from India
Asad, thank you so much for the kind comments and the recommendation! I'm very happy that you liked the video, thank you for your support!
Great follow-up Andrew. Thanks for the video.
Thanks Kevin, glad you liked it and thanks for the comment!
Its amazing. Wounderfully explained. Thanks much.
My pleasure Rohith, thanks for the support!
Diamond. Thank you for this video!
You're welcome, thanks for watching!
Hi Mr. Wise Owl! I know that this vid was from 2 years ago but this really helps a lot and with that, I want to say thank you! Also, is there a way or a separate video for looping thru specific cells then pasting it on textboxes in PPT? Thank you again for this Amazing Video!
Or maybe not a loop, like specific cell to specific textbox.
Right now I have like..
Set sh = sl. Shapes(2)
Range("Cell that I wanted to copy").Copy
sh.TextFrame.TextRange.Paste
Set sh = sl. Shapes(3)
Range("Cell that I wanted to copy").Copy
sh.TextFrame.TextRange.Paste
And so on...
@@jaaaaayz Hi! There's no convenient way to do this that doesn't involve lots of setup work. The last time I did this for a client I gave each cell that I wanted to copy from a unique range name and then gave the same name to the PowerPoint shape that the cell needed to be copied to. I then looped through the Names collection of the workbook, using the Name property of each Name object to map the cell to a shape.
I hope that points you in the right direction!
Do you have any videos explaining how to create a table, say, in the final slide of a presentation that can populate variables throughout the other slides? I can't find ANYTHING on that.
Thank you for the video! New to vba here but is there a way you can refer to the presentation if it is already open on your desktop? I keep getting a runtime error when I try to set pres = ActivePresentation
Hi Stephanie! Yes, if the presentation is already open you can reference it like so:
Dim ppt As PowerPoint.Application
Dim pres As PowerPoint.Presentation
Set ppt = GetObject(Class:="PowerPoint.Application")
'refer to active presentation
Set pres = ppt.ActivePresentation
'refer to named presentation
Set pres = ppt.Presentations("Presentation1.pptx")
I hope it helps!
Hi Wise Owl! I have an odd thing I'm trying to do, but with no real background in Visual Basic. I'm trying to create a PowerPoint where the text and all formatting from one text box will automatically copy to other text specific boxes on other slides throughout a presentation. For context, this is the "daily schedule" for a museum, and I'm attempting to make the daily schedule auto populate across multiple slides. Thanks in advance for your help regardless!
Hi! It's difficult to provide detailed advice without knowing exactly how your presentation is structured, but if you want to copy an entire text box from one slide to another, this basic code will work:
Sub Copy_Text_Box()
ActivePresentation.Slides(1).Shapes(1).Copy
ActivePresentation.Slides(2).Shapes.Paste
End Sub
If you want to copy the contents of a text box into another existing text box (including the formatting) try something like this instead:
Sub Copy_Text_Box_Contents()
ActivePresentation.Slides(1).Shapes(1).TextFrame2.TextRange.Copy
ActivePresentation.Slides(2).Shapes(1).TextFrame2.TextRange.Paste
End Sub
I hope it points you in the right direction!
Thank you WiseOwl for this video and the way you explain things is amazing and super clear. By the way I did not get one thing, how do I know which is the index of a shape in a existing ppt deck?
Hi Paolo! There isn't a property to return the index of a shape as far as I know. The answers here show a way to loop through the Shapes collection to determine the index number stackoverflow.com/questions/53242865/get-shape-index-in-powerpoint-vba
I hope it helps!
Hi Sir. I am regularly following your videos and your explanation is very clear. 100% working
I have a requirement there is a table in Excel which is formatted with blue colour header and white colour for table
Need to copy this into ppt slide as editable, don't want excel pop-up or other link .....
.
Tried in many ways not able to crack it.
Hi Prasanth! You might find this video useful ruclips.net/video/e1kUWZqCkRw/видео.html I hope it helps!
@@WiseOwlTutorials Thank you so much it's working..... 😊😍
Thakyou Andrew!!! Video is very helpful
Also can you please let me know how to copy specific charts into specific slides ?
It will be very helpful. Thanks in advance
Hi Vivek! This is an older video but you ma y find it useful ruclips.net/video/v_Mv2f9GZ5M/видео.html
I hope it helps!
Thank you so much, it is a great video!
But what if I want a specific cell value a number for example to be pasted within a paragraph in PPT ?
Would really appreciate your help about this!
Hi!
docs.microsoft.com/en-us/office/vba/api/powerpoint.textrange
Use one of the following methods to return a portion of the text of a TextRange object: Characters, Lines, Paragraphs, Runs, Sentences, or Words.
Use one of the following methods to insert characters into a TextRange object:InsertAfter, InsertBefore
Going to use this to lazily relabel power point slide titles so I only need to type in a city's name once into an excel file and everything just goes my way.
Good idea - work smarter, not harder!
Sadly I can not finish the video. After you write your script and press F5 to open your powerpoint presentation, I run into an error. It highlights the 2nd line "ppt As PowerPoint.Application" and says Conpile error: User-defined type not defined. Everything in my script is word-for-word what you typed.
Hi! It sounds like you haven't referenced the PowerPoint object library.
I was literally looking for a video on excel to powerpoint similar object to this. I couldn't find anything useful and then you upload it.. I can't thank you enough. I have a question though, I want to use this method to create complicated and rich quotation. Assuming I have 30-40 boxes in a slide, is there a way to find which box is which other than just trial and error method?
Hi there! You can use the Selection Pane in PowerPoint to see the names of objects on a slide. There are several ways to open the Selection Pane, try Home | Arrange | Selection Pane.
You can click an object to find out its name. You can double-click an item in the Selection Pane to rename an object. You can reference the name of the object in VBA for example like this:
ActivePresentation.Slides(1).Shapes("Title 1")
I hope that helps!
@@WiseOwlTutorials I see, didn't know about these options of ppt at all. You are trully godsend.Thank you!
@@vengion1379 You're very welcome, I hope it helps!
Thank you so much for posting this video! This is amazing!
My work requires me to create certificates weekly, with the data (names, date, etc) stored in excel, then the certificate template is in powerpoint.
Each week, I need to create between 20 to hundreds of certificates, so you can just imagine how much copy and pasting I do.
I was wondering if it is possible to do this copy pasting using this method. Maybe with looping the code until the end of the last data in the excel table?
Also, can we add slides based on how many data is in the excel table?
If you can point me to some resources about this, that would be awesome too
Hi! We have a few videos on using VBA with PowerPoint which you can find by heading to the WiseOwl channel page and searching for PowerPoint ruclips.net/user/WiseOwlTutorialssearch?query=powerpoint
I hope it helps!
do you have any answer for this one?
I also need this one as well. hehehe
Hi! Just thought you'd like to know that I've posted a members-only video showing how to do this ruclips.net/video/WOKKN03NVjs/видео.html