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.

Excel - how to prevent new office version from upgrading word object reference
 

On 4 Jul 2006 09:49:40 -0700, Zoner wrote:

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).

[...]

Remove any Word reference from VBA project and use late binding.

--
PL

Excel - how to prevent new office version from upgrading word obje
 

Remove the references and use this code to create your word application
object...

dim appWord as object

set appWord = createobject('Word.Application")

--
HTH...

Jim Thomlinson


"Zoner" wrote:

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.

Excel - how to prevent new office version from upgrading word obje
 

Remove the references and use this code to create your word application
object...

dim appWord as object

set appWord = createobject('Word.Application")


Thanks!

I have this working for Word.Application but can not seem to use the
same method to replace:
Dim wRng As Word.Range
With:
Dim wRng As Object
Set wRng = CreateObject("Word.Range")

- I get an error on the Set wRng saying it can not create the object.

Should this work? I am also using Word.Table, so suspect I will get the
same error there.

Thanks again.

Matt