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

Can't save my Office documents (after computer rebuild and reauthorization) 0
Problems starting Word from Excel VBA 3
Help with calling word reference from excel vba 7
Running Excel 12.0 Application on Office 2003 2
Missing References 2
VBA Form with Calendar Control - Excel 2002 to 2003 compatibility 4
Exporting Data to Word 2007 Using Reference to Word 11.0 Library 1
Excel 2003 with VBA - "Can't find project or library" 6

Top