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

G

goheaven

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
 
J

Jean-Yves

Hi,
Got that problem at work
Remove totally that ref and use late binding for compatibility.
Regards
JY
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with calling word reference from excel vba 7
Same Office 2003 but different VBA Tools>Reference (object ref.) 5
Running Excel 12.0 Application on Office 2003 2
How to dynamically add/change Reference? 2
Error opening Word document from Excel VBA code 3
Any library issues when giving XL2003 wkbk to XL2000/2002 users? 2
Exporting Data to Word 2007 Using Reference to Word 11.0 Library 1
VBA Refrerences which interfere 3

Top