Excel VBA, won't recognize "Word.Application" object

[Skyron]

I give... I NEED to control word from excel or vice versa.

I know about the line
"Dim wrdApp as Word.Application"
Though everytime I try this in excel I can't get any response, it give
me an error for that line. It's as if the "Word" object doesn't exist
I've looked everywhere!! Is there a library I can add t
excel's vba? What's the missing link?!?! It's an easy fix isn't i


I will buy beers for whoever can help me out here!!

Thanks Guy

 

[Nigel]

You need to set a library reference to Word, in the VBA editor goto
Tools->References and chekc the box for Microsoft Word 10.0 Object Library.
That should do it.

The version may be different depending on your copy of Excel (10 refers to
Excel 2002)

Cheers
Nigel

 

[Ron]

Hello Skyron

I believe you need to add the word library.
From the VB Editor menu select Tools > References and check Microsof
Word 9.0 Object Library.

Ciao

Ro