Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. 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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why do i "sometimes" need to "edit chart object" before "source da | Charts and Charting in Excel | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Browse a multi-pages "microsoft word document" object in Excel 200 | Excel Discussion (Misc queries) | |||
What does "Application-defined or object-defined error" mean? | Excel Programming | |||
"Application-defined or object-defined error" while printing excel report | Excel Programming |