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

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
:confused: 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

--
Message posted from http://www.ExcelForum.com

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

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

"Skyron " wrote in message
...
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 gives
me an error for that line. It's as if the "Word" object doesn't exist.
:confused: I've looked everywhere!! Is there a library I can add to
excel's vba? What's the missing link?!?! It's an easy fix isn't it
:)

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

Thanks Guys


---
Message posted from http://www.ExcelForum.com/

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

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

--
Message posted from http://www.ExcelForum.com