You are in the right direction. Remember that certain objects are not
available in older versions and likewise for newer versions, so a early
binding reference will give compile errors if they are not compatible with
the version you are running the code in.
--
Regards,
Shyam Pillai
Animation Carbon
http://www.animationcarbon.com
"GoTTi" <c_von_schwerin[ at ]hotmail.com> wrote in message
news:%23ObtKem1GHA.4264[ at ]TK2MSFTNGP05.phx.gbl...
[Quoted Text] > I'm getting the errors when I'm running the code but in the meantime I > found a MS article on that ( http://support.microsoft.com/kb/245115/) which > pretty much give me some hints - I think I'm gonna sort this out. > > Thank you! > Regards, > GoTTi > > "Shyam Pillai" <ShyamPillai[ at ]Gmail.com> wrote in message > news:OtRsi8l1GHA.4388[ at ]TK2MSFTNGP03.phx.gbl... >> The references change based on the Product installed on the system. Are >> you getting errors when you run the code or do you get errors with the >> reference? >> >> -- >> Regards, >> Shyam Pillai >> >> Animation Carbon >> http://www.animationcarbon.com>> >> >> "GoTTi" <c_von_schwerin[ at ]hotmail.com> wrote in message >> news:%23gAAJIl1GHA.328[ at ]TK2MSFTNGP06.phx.gbl... >>>I have written a macro in Excel 2002/XP which uses different MS Object >>>Libraries (Excel, Office & PowerPoint) and it works fine. >>> When I save the file in Excel 2003 the references get changed >>> automatically to version 11 and the file works but when I open the file >>> in Excel 2002 again the Object Library for PowerPoint stays on version >>> 11 all others swiches back to version 10. This produces errors. >>> >>> Does anyone have a clue why this Object Library doesn't swich back? >>> >>> Thanks in advance >>> GoTTi >>> >> >> > >
|