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.
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. th-cam.com/play/PLo0aMPtFIFDocT-bLo37Fj_iwenKtUlKr.html
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.
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
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?
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. th-cam.com/video/s9HE5uIGYAI/w-d-xo.html
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
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.
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
Hello AJ I have a list of different power point files that are to be presented according to a schedule described in an excel spreadsheet. Please I need a breakdown I'm totally confused
Thanks a ton. Also, If there is an exception where we wanted the tables to be pasted as editable tables only, then how to modify the code ? As the for loop pastes all charts& tables as bitmap only
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 :)
I have one requirement, I have 1000's of images. I have a client who would like to have three images per slide in ppt from that library and the combination can be any three pictures. Will it be possible to do in macros?
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.
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
Thanks
thanks for you support!
Most practical and best VBA Programming Channel !!!
thank you so much!
Wow, thanks!
This is superb. No doubt best VBA channel
Thanks for watching!
Project Uploaded. Download and have fun. Cheers!
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
Look forward to new contents from you. Thanks for your contribution to VBA community.
Much appreciated!
amazing how you simply VBA automation. another great video. Thank you
Thanks again!
Bravo!!! your contents are mind blowing.
Thanks for sharing your knowledge to VBA lovers
So nice of you
Your videos are the most practical. thank you so very much!
You're very welcome!
Learned amy more things everyday. Thanks for sharing your experience and knowledge freely
So nice of you
Best VBA channel. Thanks sir
So nice of you
VBA A2Z - Awesome tutorial!! very deliberate, organized, and concise... I echo Mira's comment.
Much appreciated!
This is best tutorial i have come across in ppt automation! Keep it up 👍
Wow, thanks!
Another amazing video. Thank you so much for teaching us
My pleasure!
this is wow. really great practical tutorial
thanks
superb! will come back for more.... thank you thank you
So nice of you
Thanks for excellent tutorials
You are welcome!
Thank you sir for detailed walk-through and for another practical video.
most welcome
Brilliant work man, keep posting
Glad it helped!
Really useful video. You’re the man!
I appreciate that!
This is excellent solution. Keep up great work.
Thank you! Cheers!
Thank you so much. Your channel is a gem.
I binge-watched UI UX series :)
Glad you enjoy it!
Big thanks to Pamai
you're most welcome!
Exactly what I needed, thanks for the great video!
You're welcome!
another useful tutorial. keep it up!
Glad you think so!
Learn many new things from your channel. You have a great knowledge base, thank you Pamai
Happy to hear that!
Another great tutorial. Thanks Pamai
thanks!
Thanks for this amazingly practical tutorial. Keep up great work
Thanks, will do!
@@VBAA2Z cheers!
thanks for another practical video
You're welcome
Really loved all your videos. Keep it up!
Thanks a ton!
What a brilliant idea! Thank you
You are so welcome!
this is brilliant, thank you
You're very welcome!
Excellent tutorial. Subscribed, Liked, Saved to Playlist and Notification turned-on... :-)
Awesome, thank you!
Thank you again for this great tutorial.
Glad it was helpful!
Thansk for amazing tutorial
My pleasure 😊
Excellent solution and tool. Thank you for your efforts 😀👍
You are welcome!
Very Very useful to me. Thanks a lot.
Glad it was helpful!
Thx a lot very useful
You are welcome
thanks for the useful videos.
Glad you like them!
Amazing. Thank you so much
You're very welcome!
this is amazing, thank you so much.
You're very welcome!
Amazing tutorials
Thanks
very helpful and understandable thank you very much!
You're very welcome!
This is extremely helpful - thanks!
You're welcome!
this is great, thank you sir
You are very welcome
Feeling very grateful. Keep it up, thanks!
Thanks, will do!
superb - thanks
Most welcome
Great value provided
Thanks Kenny!
Brilliantly put together my friend.
Thanks, appreciate that
superb, thank you soo much
you're most welcome!
This is amazing. It's going to save a lot of time
Glad to hear. Let me know if you face issues.
Thank you for this video, it was very helpful.
Glad it was helpful!
Thank you Sir !
Most welcome!
so many cool tut here!!! good work!
Glad you think so!
thank you so much
You're welcome!
This is great. Thanks for the video.
You're very welcome!
@@VBAA2Z Please enable the download for me thanks
@@duperpooperscooper sure, I did not see the request come through. Is it Dennis?
Thanks for this informative tutorial.
Glad it was helpful!
This is perfect! Thank you very much
You're welcome 😊
very informative, thanks so much
Glad it was helpful!
Brilliant, never knew about this possibility.
thank you thank you
Happy to help
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.
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.
th-cam.com/play/PLo0aMPtFIFDocT-bLo37Fj_iwenKtUlKr.html
Thank you and keep up the good work Sir
Thank you, I will
Great work.
Thank you! Cheers!
Great work man! 👍
Appreciate it!
Wow this is excellent! Thank you
You're very welcome!
thank youso much!!!!
You're welcome!
It's Cool n Amazing
Glad you found it useful. Cheers!
thank you
You're welcome
مرسی
thanks for visit.
brilliant idea. thank you so much
Most welcome 😊
This is excellent sir. You're the best!
Requesting you to create video on how to create add-in for PowerPoint. Thanks for considering
thanks. Will upload soon
simply amazing. How do you come up with all these
Thank you! Cheers!
fantastic!
Thank you! Cheers!
Love the video ! Subscribed !
Thanks for the sub!
great video
Glad you enjoyed it
this is a great tutorial, thanks.
You're welcome!
Hi, is it possible to buy the code you have created in the instruction?
Yes please check out here vbaa2z.blogspot.com/2020/12/you-can-support-vba-a2z-by-simply.html
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.
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
Hello! Can the user interface be in the same document as de excel data source?
yes, of course.
thanks,, is it possible to export the slide position from ppt to excel
yes, in the same way demo in the beginning
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
Most welcome. Not at my desk at the moment, you should see the options in .PasteSpecial
Good
thanks
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?
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.
th-cam.com/video/s9HE5uIGYAI/w-d-xo.html
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
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
'---------
Is it possible to copy only certain cells and paste them into PowerPoint? What should i do different
you process will be same.
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.
Can this be done in ms access? this is really useful, thanks
Yes, absolutely
How did you delete all the columns after the N column in 3:23?
Hi Isai, the Columns are hidden not deleted.
Select all columns, right click on Column and click on Hide
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
Hello AJ I have a list of different power point files that are to be presented according to a schedule described in an excel spreadsheet. Please I need a breakdown I'm totally confused
try posting your question to stackoverflow . com
Alright thanks
great
thanks!
Hellow Pamai
A nice video like always. Would appreciate if you start a series for GDI/GDI+ using VBA
Thanks for your suggestion.
Can this be done for access too?
yes of course
Thank you for this unique tutorial! Can I do something like this but export by MS access instead of excel?
Yes you can. set reference to PPT Library as demo in this video and read data from Access table.
@@VBAA2Z Wow! thank you 🤩
Hi , the video is super useful. Just one doubt , if this slide is prepared monthly , how to ensure the code also deletes previous tables/charts ?
Glad to hear. Try something like this
ActivePresentation.Slides(1).Shapes(1).Delete
Thanks a ton. Also, If there is an exception where we wanted the tables to be pasted as editable tables only, then how to modify the code ? As the for loop pastes all charts& tables as bitmap only
Hi, what if you have already existing shapes in the ppt template? how do you get around this with the set shp line?
check out this full tut on PPT th-cam.com/video/s9HE5uIGYAI/w-d-xo.html
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 :)
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.
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!
Thanks. Please check the video description
I have one requirement, I have 1000's of images. I have a client who would like to have three images per slide in ppt from that library and the combination can be any three pictures. Will it be possible to do in macros?
yes that should be possible.
@@VBAA2Z Thanks, if you are interested to do a new video; please take this as it will have many learning points.
@@gnsarathbabu this series covers most topics in PPT Automation
th-cam.com/video/dIqoXYy_Clg/w-d-xo.html
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.
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
This is powerful, can we do the same with word document?
yes, please check this video.
th-cam.com/video/RQgOxv6nrE0/w-d-xo.html