any idea why the language was designed this way? why would it lock in a very particular version of the library when it compiles? I think an option would be useful, when you go to export it, to tell it to use late binding instead of needing to go through and change all the code.
It's honestly hard to know and answer. The VBA language is older, so it's hard to say what some of the challenges would've been back then to incorporate the functionality you're talking about. I agree that it would be nice to have some type of option when we export our module to specify whether you want late or early binding. However, the issue would be is that it would have to read your code and know what components used early vs. late. Not impossible, just challenging.
Here is the link to MSDN Official Documentation for the PowerPoint Enumerations. Just an FYI, there are multiple enumerations because different objects have different enumerations. docs.microsoft.com/en-us/office/vba/api/powerpoint(enumerations) Slide Layout: docs.microsoft.com/en-us/office/vba/api/powerpoint.ppslidelayout Paste Data Types: docs.microsoft.com/en-us/office/vba/api/powerpoint.pppastedatatype
Excellent video, very clear explanation. Thanks ❤❤👍👍
Thank you!
You bet!
Is it possible with code in Excel VBA to tell where on each slide in Powerpoint to postion, say for instance a range?
Thanks
any idea why the language was designed this way? why would it lock in a very particular version of the library when it compiles?
I think an option would be useful, when you go to export it, to tell it to use late binding instead of needing to go through and change all the code.
It's honestly hard to know and answer. The VBA language is older, so it's hard to say what some of the challenges would've been back then to incorporate the functionality you're talking about. I agree that it would be nice to have some type of option when we export our module to specify whether you want late or early binding. However, the issue would be is that it would have to read your code and know what components used early vs. late. Not impossible, just challenging.
Will you please post the link for the numbers in the enumeration process? Not sure what to google to get it for myself! =)
Here is the link to MSDN Official Documentation for the PowerPoint Enumerations. Just an FYI, there are multiple enumerations because different objects have different enumerations.
docs.microsoft.com/en-us/office/vba/api/powerpoint(enumerations)
Slide Layout:
docs.microsoft.com/en-us/office/vba/api/powerpoint.ppslidelayout
Paste Data Types:
docs.microsoft.com/en-us/office/vba/api/powerpoint.pppastedatatype