VBA Reference Library Problem

[scottmcclean]

I wonder if you could steer me in the right direction.....

I originally created a number of excel VBA forms in Excel 2007. My system had to be upgraded and I now use Office 2010. I have to regularly update these forms with new functionality for my team, all are using office 2007. All forms use a an MS WORD module and an OUTLOOK module. Whenever the users open the forms after an update they get a debug error - which means I have to pop round to each of them and change the reference library entries for Outlook and Word.

Is there a way that this can either be done automatically, or a way I can save as a 2007 version?

[:) Sixthsense :)]

Use Late Binding Method instead of Early Binding

[scottmcclean]

Hi Sixthsense, am fairly new to VBA - how do I achieve this?

[:) Sixthsense :)]

Check these links to know how to use it

http://word.mvps.org/FAQs/InterDev/E...ateBinding.htm

http://support.microsoft.com/kb/245115

http://excelmatters.com/2013/09/23/v...-late-binding/

[romperstomper]

Cross-posted : http://www.mrexcel.com/forum/excel-q...y-problem.html