View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] goheaven@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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