Hello - I have (what started out as) a 2010 xlsm, with object library references to v14.0 Office and PowerPoint (and VBA, Excel and OLE). Then I learned that this workbook will be used by both Office 2010 & 2013 users (over SharePoint).
When I copy it over to a laptop running Office 2013, all the Office ref's automatically update to version 15.0
But when I move *that* copy back over to my Office 2010 laptop, the Office ref goes back to 14.0, but the PowerPoint stays at 15.0.
I put in some code to check the PP ref:
If ThisWorkbook.VBProject.References("PowerPoint").IsBroken Then
but it errors out with "Error loading dll"
Is there a way to check and fix ref's when the workbook opens?