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!!
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!
This is really amazing sir... Please continue to make videos like this...Very useful ❤
Fantastic Video presentation.
Very useful feature for creating PP Dashboard from Excel.
exciting! Good explained as well. thank you
Great video. You the best !!!I learned a lot. But I don't know much about VBA, Would love to learn it though.
You are a life saver!!thank u so much...
This is so impressive.
This is great! Thank you.
nice...thank you ..mantaps❤
Great, I have subscribed your channel, thanks for sharing valuable videos
Thanks and welcome!
Thank you so much, it is very helpful
Amazing video!!!
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,
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!
Excellent... Thanks a lot..
Most welcome!
Thank you so much. What about if I have three or four different sheets instead of one sheet?
Brilliant, which Font & size you have used
Please arrange a crash course for VBA coding
good day sir me i ask a question how to create this kind of excel to make it editable in powerpoint not photos type.
رائع جداً 👍
Can we operate slicer in ppt
Do you have a VBA programing 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???
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!!
you are superb
Thank you!!
Amazing
Where are you from sir? you are great!!
Thank you!
I am from Canada 🇨🇦
❤
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
pl give vba code
Please make crash course on VBA
Sure will release soon!!
I need the crash course :( I'm not versed in the coding.
VBA PROGRAMMING COURSE PLEASE
Showwwwww
Code not found in description
Where's the code?
Pls share this vba code in chat
I dont know anything about VBA
Where is code??