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. ru-vid.com/group/PLo0aMPtFIFDocT-bLo37Fj_iwenKtUlKr
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
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
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
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
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.
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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-s9HE5uIGYAI.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 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 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 for the descriptive video, I tried doing it, however, getting Run time and compile error when trying to run the get position and get from PPT macro. Please guide.
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 :)
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, but when i execute the code, getting the error as "Cant execute code in break mode..and stops at the command set shp = nothing...please help on this error.
Sir i am updating sharepoint list through vba, i want to know how many rows i can update through vba into sharepoint list, is there a limit and how many rows i can store into sharepoint list