Wow! Great video! I’m still new to VBA, but I used one of your other videos to build a LogMessage into one of my applications. Very Helpful, thank you!
Code errors out at this line Set pptShape = pptSlide.Shapes(pptSlide.Shapes.Count) Shaoe ( Unknown Member) : Integer out of range. 0 is not in the valid range of 1 to 0
It looks like the shape isn't copying over to PowerPoint properly. Make sure you have a shape selected in the workbook before running the macro. Also change false to true when adding the presentation to be able to see the PowerPoint application, which should help you diagnose what's going wrong. Let me know how you go.
@@YourVBTutorI have a shape selected, I had already set this to Set pptPres = pptApp.Presentations.Add(msoTrue), I also changed the .Fill.ForeColor.RGB = RGB(34, 139, 34) to a Green color and put a breakpont at pptShapeRange.MergeShapes msoMergeSubtract. Powerpoint opens and the green shape is there. It errors at the next line of code.
Sorry that you're experiencing issues. Feel free to send me an email with a screenshot of the code so I can diagnose the issue properly. yourvbtutor@outlook.com
Thank you, sir!
Thanks for watching 🙂
Wow! Great video! I’m still new to VBA, but I used one of your other videos to build a LogMessage into one of my applications. Very Helpful, thank you!
Great to hear! Logging is a fantastic tool for professional app building. Well done! Thanks for watching 🙂
Great! That is really cool! Thank u very much!😊
Glad you enjoyed! Thanks for watching.
👏👏👏👏Excellent! A little too fast for my ability. Any chance of getting the code?
Thanks for watching. Glad you enjoyed. Feel free to pause throughout the video to give yourself a chance to copy the code. 😊
@@YourVBTutor i agree with this statement. you learn the code better by manually typing the code instead of just copy pasting the code.
@CoderzF1 Yes I absolutely agree. There is no better way to learn than by doing.
That's really cooool! Thankyou for thiss!
Thanks for watching! 😊
Code errors out at this line Set pptShape = pptSlide.Shapes(pptSlide.Shapes.Count) Shaoe ( Unknown Member) : Integer out of range. 0 is not in the valid range of 1 to 0
It looks like the shape isn't copying over to PowerPoint properly. Make sure you have a shape selected in the workbook before running the macro. Also change false to true when adding the presentation to be able to see the PowerPoint application, which should help you diagnose what's going wrong. Let me know how you go.
@@YourVBTutorI have a shape selected, I had already set this to Set pptPres = pptApp.Presentations.Add(msoTrue), I also changed the .Fill.ForeColor.RGB = RGB(34, 139, 34) to a Green color and put a breakpont at pptShapeRange.MergeShapes msoMergeSubtract. Powerpoint opens and the green shape is there. It errors at the next line of code.
Sorry that you're experiencing issues. Feel free to send me an email with a screenshot of the code so I can diagnose the issue properly. yourvbtutor@outlook.com
❤❤❤
Thanks for watching 😊