Open excel 2010 workbook in excel 2007 missing references

[Snoopy2003]

Hello,

I create an excel 2010 application. When it is opened in excel 2007
there are missing references to outlook 14, excel 14 object library,
Microsoft office 14 object library. I wish to update vba references when the
file is opened and avoid do it manually,

How can I do it using VBA ?

I found code for office 97 and 2003. Is there any example for office 2010 & 2007 ?

Thank you for your help

[Snoopy2003]

Hello,

I found an example of code but it does not work.
I wish to update the references to outlook, excel and powerpoint according to
the installed version of the user.

Can you help me ?

Thank you

Please Login or Register  to view this content.

[royUK]

Normally the references work backwards. Can you attach an example?

[Snoopy2003]

Hello,

I attached an example file with send mail module.
The file was created with excel 2010 and has a reference to outlook 14 object library.
When opening the file in excel 2007 there is a missing reference:
"Missing reference Microsoft outlook 14 object library"


Can you help me to solve it ?
(remove the missing reference and add the correct one according to the office version)

Thank you for your help