I have an appolication which I have written in Excel 2007 but I also use it on my laptop which has Excel 2010 on it. I have to access the save files from both PCs. The application Emails so has a reference to the Microsoft Outlook 12.0 Object Library.
When I open this file in XL2010 it works fine, 'magically' the reference getws changed to Microsoft Outlook 14.0 Object Library.
When re-open the file after it has been saved by XL2010 in XL2007 there is, understandably, a missing reference, to the Microsoft Outlook 14.0 Object Library. What I have to do in untick the missing references and re-tick Microsoft Outlook 12.0 Object Library. This is becoming tiresome.
Is there a way, other than I suppose copying the Microsoft Outlook 14.0 Object Library file onto my XL2007 PC, of configuring my application to work both in XL2007 and XL2010 without the reference tweak?
