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?
@skillnator.. Hi. I am facing an issue while using the code. The following error is popping up while executing: "Runtime Error '1004': CopyPicture method of Range class failed". I tried different ways.. once in 5 or 6 times its working, All other cases this error is popping up. Do you have any solution for this???
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
This is really great opportunity those who interested to explore Dashboard.
Thank you for share your knowledge.
You are one of the best teachers I have seen
Great work and timely video! Thanks for creating this content!!
Fantastic Video presentation.
Very useful feature for creating PP Dashboard from Excel.
This is really amazing sir... Please continue to make videos like this...Very useful ❤
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!
exciting! Good explained as well. thank you
This is so impressive.
You are a life saver!!thank u so much...
nice...thank you ..mantaps❤
Great video. You the best !!!I learned a lot. But I don't know much about VBA, Would love to learn it though.
Thank you so much, it is very helpful
This is great! Thank you.
Amazing video!!!
Great, I have subscribed your channel, thanks for sharing valuable videos
Thanks and welcome!
Thank you so much. What about if I have three or four different sheets instead of one sheet?
Excellent... Thanks a lot..
Most welcome!
good day sir me i ask a question how to create this kind of excel to make it editable in powerpoint not photos type.
رائع جداً 👍
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?
Brilliant, which Font & size you have used
Do you have a VBA programing video?
Can we operate slicer in ppt
Hi,
It was very good technique shown from excel to PPT
But can made a crash course for macro, bcoz i want to learn it
Its a work in progress. Will try to release it soon!
you are superb
Thank you!!
Amazing
Please arrange a crash course for VBA coding
@skillnator.. Hi. I am facing an issue while using the code. The following error is popping up while executing: "Runtime Error '1004': CopyPicture method of Range class failed". I tried different ways.. once in 5 or 6 times its working, All other cases this error is popping up. Do you have any solution for this???
❤
pl give vba code
Very nice. But how does it update the same presentation with new values each month for example? It seems it just creates a new presentation each time?
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!!
Where's the code?
Code not found in description
Awesome presentation! But I could not find the VBA code.
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
I need the crash course :( I'm not versed in the coding.
Showwwwww
VBA PROGRAMMING COURSE PLEASE
Where are you from sir? you are great!!
Thank you!
I am from Canada 🇨🇦
Please make crash course on VBA
Sure will release soon!!
I dont know anything about VBA
Where is code??