I have an excel sheet that I created in MS Office 2003 that contains a number of VBA modules. I have send this spreadsheet to another one of our offices that has MS Office 2010.
I have to do a bit of de-bugging on their edition of the spreasheet but when they send it back and I try to open certain modules i get a "Missing DLL" error.
I have gone to Tools > References and there is indeed a missing reference (MISSING: Microsoft PowerPoint 12 Object Reference). I have tried unchecking this one and checking the PowerPoint 10 reference, but every time I press OK, it just seems to revert back to the version 12 and the error comes back again (when i go into the references dialogue box, 12 is checked and 10 is unchecked).
Can anyone help?
I have to do a bit of de-bugging on their edition of the spreasheet but when they send it back and I try to open certain modules i get a "Missing DLL" error.
I have gone to Tools > References and there is indeed a missing reference (MISSING: Microsoft PowerPoint 12 Object Reference). I have tried unchecking this one and checking the PowerPoint 10 reference, but every time I press OK, it just seems to revert back to the version 12 and the error comes back again (when i go into the references dialogue box, 12 is checked and 10 is unchecked).
Can anyone help?
