View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Zoner Zoner is offline
external usenet poster
 
Posts: 3
Default Excel - how to prevent new office version from upgrading word object reference

Hi all...

I have an excel spreadsheet, with Macro's which control Microsoft Word.
They were written using Excel and Word from Office 2000 (Word 9.0).

This is a shared spreadsheet, so some other users have Office XP. After
they open the spreadsheet and make changes, the referece to the
Microsoft Word Objects in the VBA editor is upgraded to V11.

When the spreadsheet is then opened in Excel 2000, errors messages
popup. I then have to remove the "Missing Word 11.0" reference and
re-check the Word9.0 reference.

Is there a way to prevent this from happening?

Thanks in advance. Matt.