Thank you so much for sharing this video - I definitely need to learn more about VBA code. Please forward me to code to open Powerpoint from Excel. Just finished watching your other video, creating interactive dashboards in 5 steps. This is really an amazing video, thank you!
Really helpful video, thank you, will be using this very soon!! But I do need to learn more about VBA code - please can you send me details about this as you mentioned in your video?
Hi, thank you for your question. You will need to tweak the code a bit to achieve this. In the section of the code which says "Set up a power point file", put in the following code: 'Set up a power point file On Error Resume Next Set PApp = GetObject(, "Powerpoint.Application") If PApp Is Nothing Then Set PApp = New PowerPoint.Application End If If PApp.Presentations.Count = 0 Then Set PPres = PApp.Presentations.Add Else Set PPres = PApp.ActivePresentation End If Set PLayout = PPres.SlideMaster.CustomLayouts(1) ''''''''''''''' Furniture Category ''''''''''''''''''''''''''''' Rest of the code remains the same. With this modification, the code will create a new presentation if none is open already. If there is one open already, then it will add a new slide to the one currently open presentation. Hope that helps!!
Hi, You can dowlonad the file from below link. There are two files in there, please download the one with "xlsm" extension. Once you open the file, go to VBA editor (keyboard shortcut Alt + F11). You should be able to see the entire code there. Hope that helps. drive.google.com/drive/folders/1ZsA2-2knQSnrteNWJ13UL67xTS4zHBFX?usp=share_link
