Office XP VBA can't find reference after saving by Office 2003
 

Situation is:
1) I created VBA in Excel XP, and added reference to "Word" object --
version 10.0
2) I open that Excel in Excel 2003, and now the reference automatically
changed to -- version 11.0 Word object
3) I saved file, then open it again in Excel XP

Now the reference to "Word" object shows "missing" in VBA project, and
it still refer to version 11.0.

Any idea how to fix that? Instead of modifying the reference in VBA
project.

Can we stop auto update of dll reference in Excel?

Regards,
Robin

Office XP VBA can't find reference after saving by Office 2003
 

Hi,
Got that problem at work
Remove totally that ref and use late binding for compatibility.
Regards
JY
wrote in message
ps.com...
Situation is:
1) I created VBA in Excel XP, and added reference to "Word" object --
version 10.0
2) I open that Excel in Excel 2003, and now the reference automatically
changed to -- version 11.0 Word object
3) I saved file, then open it again in Excel XP

Now the reference to "Word" object shows "missing" in VBA project, and
it still refer to version 11.0.

Any idea how to fix that? Instead of modifying the reference in VBA
project.

Can we stop auto update of dll reference in Excel?

Regards,
Robin