Automate PowerPoint Presentation using VBA. Excel PowerPoint Integration

Automate PowerPoint Presentation using VBA. Excel PowerPoint Integration
Subscribe, Like, and Comment. 🙏Thanks for watching.
You can now support by buying any of the Projects or Source Code.
📥Downloads: pamaitech.com/downloads/
👍 Support: paypal.me/pamaitech
✉️ Contact: [e-mail]
📌What to watch next:
Playlist: czcams.com/users/vbaa2zplaylists
Videos: czcams.com/users/vbaa2zvideos
#VbaA2z

[@penny2921]

Most practical and best VBA Programming Channel !!!
thank you so much!

[@VBAA2Z]

Wow, thanks!

[@chrish9518]

Feeling very grateful. Keep it up, thanks!

[@VBAA2Z]

Thanks, will do!

[@user-ux4hx7sy8s]

Your videos are the most practical. thank you so very much!

[@VBAA2Z]

You're very welcome!

[@SidauChe]

Exactly what I needed, thanks for the great video!

[@VBAA2Z]

You're welcome!

[@pekidonn5139]

This is amazing. It's going to save a lot of time

[@VBAA2Z]

Glad to hear. Let me know if you face issues.

[@kingqiabonmai1890]

Another great tutorial. Thanks Pamai

[@VBAA2Z]

thanks!

[@kinga334]

Really useful video. You’re the man!

[@VBAA2Z]

I appreciate that!

[@funniq]

Thank you again for this great tutorial.

[@VBAA2Z]

Glad it was helpful!

[@adrianl6409]

This is extremely helpful - thanks!

[@VBAA2Z]

You're welcome!

[@ekilunewmai7033]

Learned amy more things everyday. Thanks for sharing your experience and knowledge freely

[@VBAA2Z]

So nice of you

[@wikamdiopekiang4972]

Bravo!!! your contents are mind blowing.
Thanks for sharing your knowledge to VBA lovers

[@VBAA2Z]

So nice of you

[@TheBlacknight89]

Thank you for this video, it was very helpful.

[@VBAA2Z]

Glad it was helpful!

[@mehtag7810]

What a brilliant idea! Thank you

[@VBAA2Z]

You are so welcome!

[@ApirlK]

Thank you so much. Your channel is a gem.
I binge-watched UI UX series :)

[@VBAA2Z]

Glad you enjoy it!

[@scottansir7708]

Brilliant, never knew about this possibility.
thank you thank you

[@VBAA2Z]

Happy to help

[@dampisong1369]

Learn many new things from your channel. You have a great knowledge base, thank you Pamai

[@VBAA2Z]

Happy to hear that!

[@podcastmachine8617]

Love the video ! Subscribed !

[@VBAA2Z]

Thanks for the sub!

[@sylvin3406]

Look forward to new contents from you. Thanks for your contribution to VBA community.

[@VBAA2Z]

Much appreciated!

[@linnick9235]

Thanks for this informative tutorial.

[@VBAA2Z]

Glad it was helpful!

[@Mira-kp5di]

This is superb. No doubt best VBA channel

[@VBAA2Z]

Thanks for watching!

[@ShrutamJani]

Excellent solution and tool. Thank you for your efforts 😀👍

[@VBAA2Z]

You are welcome!

[@lchewang6512]

Brilliantly put together my friend.

[@VBAA2Z]

Thanks, appreciate that

[@user-oy3zj3zr2w]

amazing how you simply VBA automation. another great video. Thank you

[@VBAA2Z]

Thanks again!

[@Rahul-sn1wn]

This is best tutorial i have come across in ppt automation! Keep it up 👍

[@VBAA2Z]

Wow, thanks!

[@DorkaLiumsk]

Another amazing video. Thank you so much for teaching us

[@VBAA2Z]

My pleasure!

[@CodeLikeProz-dp8qr]

Thank you sir for detailed walk-through and for another practical video.

[@VBAA2Z]

most welcome

[@hoseal8048]

Best VBA channel. Thanks sir

[@VBAA2Z]

So nice of you

[@bindeeseaks9950]

Really loved all your videos. Keep it up!

[@VBAA2Z]

Thanks a ton!

[@anielchisi1389]

This tutorial has just changed my life. Thank you so much @VBA A2Z. Please can you advise on how to export charts/ data from multiple excel workbooks into the same powerpoint slide.

[@VBAA2Z]

Glad to know you found this video helpful. You can expand the mapping table / rng_sheets to include path for other files too and on runtime open the files and get data from it. The below series covers all important topics on VBA Programming including working with objects in lesson-1. Feel free to email me if you need more help.
czcams.com/play/PLo0aMPtFIFDocT-bLo37Fj_iwenKtUlKr.html

[@Chewangz]

Thanks for this amazingly practical tutorial. Keep up great work

[@VBAA2Z]

Thanks, will do!

[@Chewangz]

@@VBAA2Z cheers!

[@Varun-dh4mr]

Great work man! 👍

[@VBAA2Z]

Appreciate it!

[@SaraPerzYT]

Wow this is excellent! Thank you

[@VBAA2Z]

You're very welcome!

[@kingsynz8614]

This is excellent solution. Keep up great work.

[@VBAA2Z]

Thank you! Cheers!

[@Ferris-bu5yb]

so many cool tut here!!! good work!

[@VBAA2Z]

Glad you think so!

[@mithunvendra]

Very Very useful to me. Thanks a lot.

[@VBAA2Z]

Glad it was helpful!

[@benjaminf5731]

Amazed at your talent. keep up great work

[@VBAA2Z]

Thank you so much!

[@szabolcsvarjasi1679]

very informative, thanks so much

[@VBAA2Z]

Glad it was helpful!

[@Kadmao]

This is perfect! Thank you very much

[@VBAA2Z]

You're welcome 😊

[@dgitson]

this is a great tutorial, thanks.

[@VBAA2Z]

You're welcome!

[@user-ll8up1eu4d]

very helpful and understandable thank you very much!

[@VBAA2Z]

You're very welcome!

[@pedche5790]

superb! will come back for more.... thank you thank you

[@VBAA2Z]

So nice of you

[@mehmetcelik2575]

this is amazing, thank you so much.

[@VBAA2Z]

You're very welcome!

[@javierreyes7164]

VBA A2Z - Awesome tutorial!! very deliberate, organized, and concise... I echo Mira's comment.

[@VBAA2Z]

Much appreciated!

[@sidaubo]

Thanks for excellent tutorials

[@VBAA2Z]

You are welcome!

[@ajayakumarrout2700]

Thanks for the excellent video on VBA. I am quite new to it, but I could automate a PPT creation from excel using this code. One small think that I want to add is Header to each slide. I have added 'Header' as a column in the reference table of excel where we have Range and position details (as each slide will have different header). And have declared it as a variable too. But unable to call the same. Could you please help me on this.

[@jaredkulavich6081]

brilliant idea. thank you so much

[@VBAA2Z]

Most welcome 😊

[@dorwuinga]

this is wow. really great practical tutorial

[@VBAA2Z]

thanks

[@nguyenlamda8045]

Hello , the video is really useful. Thank you very much.
There is an issue that the position and size of an exported chart will not be respected as what I have defined in the admin sheet if I export more than 1 chart in a slide or if texts have been there in the ppt template ( before exporting charts).
Do you have any idea to solve this issue please ?
Thank you very much

[@GiselleBrat]

another useful tutorial. keep it up!

[@VBAA2Z]

Glad you think so!

[@kennygordon7505]

Great value provided

[@VBAA2Z]

Thanks Kenny!

[@WeningWang]

this is brilliant, thank you

[@VBAA2Z]

You're very welcome!

[@user-im4vn4yu5i]

thanks for another practical video

[@VBAA2Z]

You're welcome

[@jamesh-kc7rk]

Amazing. Thank you so much

[@VBAA2Z]

You're very welcome!

[@Manguilee-qi8to]

Big thanks to Pamai

[@VBAA2Z]

you're most welcome!

[@user-bb4rg1oi1q]

this is great, thank you sir

[@VBAA2Z]

You are very welcome

[@Imchal-hc7lo]

Thansk for amazing tutorial

[@VBAA2Z]

My pleasure 😊

[@zilacj-ng2oe]

This is amazing. Thanks

[@VBAA2Z]

Glad you like it!

[@matnz7546]

This is excellent sir. You're the best!
Requesting you to create video on how to create add-in for PowerPoint. Thanks for considering

[@VBAA2Z]

thanks. Will upload soon

[@Livinwithimagination]

Great work.

[@VBAA2Z]

Thank you! Cheers!

[@exholD]

Great tutorial!
I have a question, I would prefer to copy and paste the chart itself (even if the paste would be as an image) instead of a range containing a chart. I have tried to change the code part where we define the expRng (see below) but with no success.. Any advice?
Set expRng = Sheets(vSheet$).ChartObjects(vRange$).Select
expRng.ActiveChart.ChartArea.Copy

[@VBAA2Z]

try below samples
'---------
ActiveSheet.ChartObjects("Chart 1").CopyPicture xlScreen, xlPicture
'---------
ActiveSheet.ChartObjects("Chart 1").Chart.ChartArea.Copy
'---------
Dim Chartobj As Chart
Set Chartobj = ActiveSheet.ChartObjects("Chart 1").Chart
Chartobj.ChartArea.Copy
'---------

[@Nphum]

thanks for the useful videos.

[@VBAA2Z]

Glad you like them!

[@ChekhengKi]

fantastic!

[@VBAA2Z]

Thank you! Cheers!

[@user-fp4mh2ki7c]

superb, thank you soo much

[@VBAA2Z]

you're most welcome!

[@Petrick-ri3sq]

thank youso much!!!!

[@VBAA2Z]

You're welcome!

[@Chunchun2023]

superb - thanks

[@VBAA2Z]

Most welcome

[@FFGAMING-wv3pf]

It's Cool n Amazing

[@VBAA2Z]

Glad you found it useful. Cheers!

[@codewithme5819]

Amazing tutorials

[@VBAA2Z]

Thanks

[@bojanjovanovic756]

Thank you Sir !

[@VBAA2Z]

Most welcome!

[@user-dp5xg7wf2b]

Thank you and keep up the good work Sir

[@VBAA2Z]

Thank you, I will

[@VBAA2Z]

Project Uploaded. Download and have fun. Cheers!

[@Marschie1]

the Projekt not longer available, i get "Sorry, the page you were looking for in this blog does not exist." from the link in the description

[@garyb3455]

Excellent tutorial. Subscribed, Liked, Saved to Playlist and Notification turned-on... :-)

[@VBAA2Z]

Awesome, thank you!

[@user-ew7ke2xi2k]

thank you so much

[@VBAA2Z]

You're welcome!

[@sonalchandra100]

Hello,
Thanks for the great tutorial. Could you please help me with pasting the excel range as an editable table while retaining the source formatting ? I have tried ppPasteHTML but it's not working.
Thanks in advance for the help.

[@jeayboog9881]

This is great code that has the potential for saving me a lot of time! Thank you. One issue I'm having is switching from paste bitmap to paste default. I need to maintain the table format within powerpoint so I am using paste default. However when I use Pastedefault, the code does not reposition based on the parameters set. It simply will just paste into the powerpoint. When I switch to paste bitmap or paste enhanced metafile it works again. Any suggestions? Also how do I use this code to paste charts as the actual chart object and not a bitmap? Your help is greatly appreciated.

[@VBAA2Z]

You're welcome Jeay. Please try and post this in Stackoverflow, it is possible others also experience same issue

[@jzosopp]

Great video! Thank you.
Instead of working with ranges, is there a way to have the macro loop through Chart Names
Sheet Chart Name Width Height Top Left Slide #
IDR Charts ET1NLongTerm 5
IDR Charts ET1RLongTerm 6
I managed to get it to work with:
ActiveSheet.Shapes("ET1NetworkLongTerm").CopyPicture instead of
Set expRng = Sheets(vSheet$).Range(vRange$) '
expRng.Copy
but I can't figure out how to have the chart name dynamic. Any help would be greatly appreciated! Thank you.

[@VBAA2Z]

Sure, you can loop through charts like this
Dim c As Chart
For Each c In Application.Charts
Debug.Print c.Parent.Name & vbCrLf & c.Name
Next c

[@VBAA2Z]

Interested to become VBA Pro? Here is 100% free guided e-course with Real-life projects.
Sign-up to participate, get assignments and a certificate:-
Sing up link = > bit.ly/3eX8tzl

[@alializadeh8195]

مرسی

[@VBAA2Z]

thanks for visit.

[@user-uv1uf8cr3b]

great video

[@VBAA2Z]

Glad you enjoyed it

[@taksoneslim]

Thanks, amazing!
I was wondering if there is any way to connect an Excel sheet, lets say employee info list (one employee per row) , with PPT and make it so that each row turns converts into a separate PPT slide, for each employee, presenting all the data in a way that we can move the cell input in the slide so it looks nice and tidy? Is there a way to automatize this so I dont have to go row by row?
Cheers :)

[@VBAA2Z]

If you can fit all your data and charts etc. into Single Cell then of course. The app will export cell / range as snapshot to PPT.

[@Chafai7z11]

thank you

[@VBAA2Z]

You're welcome

[@KhalilYasser]

Thank you very much for this awesome tutorial.
I suggest using this to disable the message of updating links
With Application
.DisplayAlerts = False: .AskToUpdateLinks = False
End With

[@VBAA2Z]

Thanks Yasser! we should be able to set this in host object as well.

[@imranbhatti8580]

Hellow Pamai
A nice video like always. Would appreciate if you start a series for GDI/GDI+ using VBA

[@VBAA2Z]

Thanks for your suggestion.

[@johanneskanthak7309]

great

[@VBAA2Z]

thanks!

[@zaidsultan7310]

Thanks

[@VBAA2Z]

thanks for you support!

[@donballesteros1744]

Thanks for the excellent tutorial and for sharing the files. I would like to know (1) if i have two ranges in a sheet, how can i add those charts in 1 slide (2) how can i position those 2 charts in 1 slide . thank you.

[@VBAA2Z]

try something like this.
wb.Activate
Sheets(vSheet$).Activate
Set expRng = Sheets(vSheet$).Range(vRange$)
expRng.Copy
Set slde = pre.Slides(vSlide_No)
slde.Shapes.PasteSpecial ppPasteBitmap
Set shp = slde.Shapes(1)
With shp
.Top = vTop
.Left = vLeft
.Width = vWidth
.Height = vHeight
End With
'------------------------------------------------example for 2
nd range. Replicate it like this.
Set expRng_2 = Sheets(vSheet$).Range("A2:A10")
expRng_2.Copy
slde.Shapes.PasteSpecial ppPasteBitmap
Set shp = slde.Shapes(2)
With shp
.Top = vTop
.Left = vLeft
.Width = vWidth
.Height = vHeight
End With

[@jenshobroh1294]

Will it overwrite any pre-existing information in the "placeholders" or will it be copied on top of existing?
Example. I have a standard PowerPoint template with headers and various text that should always be intact. Will those dissapear or be kept?

[@VBAA2Z]

If you want to write to the specific shape or text box you can refer to it using a name and not index. Below is latest on PowerPoint automation. Please let me know if you're stuck happy to assist.
czcams.com/video/s9HE5uIGYAI/video.html

[@kchewang8331]

👍👍

[@michaelbaker9888]

Hi thanks for the video! How can I get the ranges to paste and resize all on the same slide? It works great putting each range on its own slide but I really need them all on one.

[@VBAA2Z]

I haven't tried this myself. If the same is to be replicated, why not just make a copy of slides instead and change the Title using VBA

[@Bonio84]

How do i change the code to support older excel versions. The tools/reference link to powerpoint object 16 isnt available in excel, only the new office 365. Therefore on my other personal laptop i get an error which i trace back to tools reference: MISSING powerpoint object 16. I untick and change it to 15 but then the code doesnt work.

[@charlesdawnbeltran9603]

Very helpful video 👍 What if the ranges are on the same workbook where you run the code?

[@VBAA2Z]

Glad to know you found this video helpful. You can expand the mapping table / rng_sheets to include path for other files too and on runtime open the files and get data from it. The below series covers all important topics on VBA Programming including working with objects in lesson-1. Feel free to email me if you need more help.
czcams.com/play/PLo0aMPtFIFDocT-bLo37Fj_iwenKtUlKr.html

[@v6kuchi]

Good

[@VBAA2Z]

thanks

[@danielstrouse1385]

This is great thank you so much!
Is there a way to export a range of slides in a subfolder from excel?

[@VBAA2Z]

Yes you can export as images or as a different PPT file. Please refer to below link
czcams.com/video/s9HE5uIGYAI/video.html

[@machdoctor]

Hi, this may be a stupid question, but where can I find the sample code/workbooks? This was a great tutorial, btw! Thank you for making it!

[@VBAA2Z]

Thanks. Please check the video description

[@RCV1337]

Hi. Great videos!! I went through the steps and it all worked!! Is where anyway to paste the shapes in PNG instead of Bitmap?
Refer to line slde.Shapes.PasteSpecial ppPasteBitmap

[@VBAA2Z]

Most welcome. Not at my desk at the moment, you should see the options in .PasteSpecial

[@zahraahareb5362]

Thank you for this unique tutorial! Can I do something like this but export by MS access instead of excel?

[@VBAA2Z]

Yes you can. set reference to PPT Library as demo in this video and read data from Access table.

[@zahraahareb5362]

@@VBAA2Z Wow! thank you 🤩

[@Valerio7777]

Hi, what if you have already existing shapes in the ppt template? how do you get around this with the set shp line?

[@VBAA2Z]

check out this full tut on PPT czcams.com/video/s9HE5uIGYAI/video.html

[@Rob-kv9kj]

simply amazing. How do you come up with all these

[@VBAA2Z]

Thank you! Cheers!

[@mikaelbohman7642]

Thank you for a great tutorial! However, I receive "compile error: Next without For" when running the macro and where it is supposed to go to Next rng. Any suggestions on how to overcome this compile error? thanks

[@VBAA2Z]

please recheck czcams.com/video/dIqoXYy_Clg/video.html
For each rng in Range("Rng_Sheets")
Next rng

[@aydeediaz2307]

Hello! Can the user interface be in the same document as de excel data source?

[@VBAA2Z]

yes, of course.

[@yyyyng43]

Hi. If the ppt template already open, can teach me what to add so that the same ppt wont be open again and will paste to already opened ppt? Hope you can help.