Same Office 2003 but different VBA Tools>Reference (object ref.)

E

Edmund

Me & my colleagues are using MS Office 2003. However, our VBA Tools>Reference
available listing aren't the same.

Mine is "Microsoft Word 11.0 Object Library" ... BUT ..... seems some of
them are 9.0.

How to make them 11.0?
 
H

Halim

Edmund,

Try to remove your missing reference in VBA window from menu Tools>Reference
and remove the MISSING:blabla...
change with the same blabla... reference with available one.
 
H

Halim

Sorry... maybe I'm missunderstanding with your post,
but your code can create object in my excel, there's no problem

actualy I'm confused what's your achievement?
 
E

Edmund

Thx Halim for helping but I guess its too difficult for me to understand at
the moment. Will try more investigating on my own. Will return again later.
Thx again.
 
E

Edmund

Sorry that I have asked too early. Just found out that it was actually ONLY
EXCEL was upgraded to 2003 version while other applications like PPT, Word
remained 2000 version for some users. Seems not everyone was lucky to have
upgraded entire Office pack.

But how can I make the below code work for those stuck with lib 9.0? Any
alternative codes?

Debug.Print Format(activecell.value, "dd-mmm-yyyy")
 

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

Trouble using VLookup in VBA 4
Running Excel 12.0 Application on Office 2003 2
Help with calling word reference from excel vba 7
Exporting Data to Word 2007 Using Reference to Word 11.0 Library 1
Any library issues when giving XL2003 wkbk to XL2000/2002 users? 2
Object Library References Question 5
missing library makes Format() disappear 2
Which references am I missing, to call Outlook from Excel VBA? 4

Top