Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel and Word
Bonjour, Hi, I was trying to export data from Excel to Word and 1) I have set a reference to Microsoft Word 11.0 Object Library in VBA 2) The begining of the code is Dim appWrd As Object Set appWrd = CreateObject("Word.Document") But HERE when I test, I have a message saying Err -2147221231 Err Automation ClassFactory can't provide the requested class (free translation of the original message in french) AND I DO NOT UNDERSTAND WHY THANKS IN ADVANCE FOR YOUR HELP / SUPPORT :cool -- freddybe ----------------------------------------------------------------------- freddybee's Profile: http://www.excelforum.com/member.php...fo&userid=1598 View this thread: http://www.excelforum.com/showthread.php?threadid=27453 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel and Word
freddybee
Change "Word.Document" to "Word.Application" If you then want to get to a document, you can Dim doc as Object Set doc = appWrd.Documents.Open(...) -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com "freddybee" wrote in message ... Bonjour, Hi, I was trying to export data from Excel to Word and 1) I have set a reference to Microsoft Word 11.0 Object Library in VBA 2) The begining of the code is Dim appWrd As Object Set appWrd = CreateObject("Word.Document") But HERE when I test, I have a message saying Err -2147221231 Err Automation ClassFactory can't provide the requested class (free translation of the original message in french) AND I DO NOT UNDERSTAND WHY THANKS IN ADVANCE FOR YOUR HELP / SUPPORT -- freddybee ------------------------------------------------------------------------ freddybee's Profile: http://www.excelforum.com/member.php...o&userid=15984 View this thread: http://www.excelforum.com/showthread...hreadid=274537 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Excel count of 1 word if found in multi-word cells of column | Excel Worksheet Functions | |||
Excel 7, paste linked to word becomes black when word pdf'd | Excel Discussion (Misc queries) | |||
Copy from Word to Excel, and retain indent, plus word wrap | Excel Discussion (Misc queries) | |||
Print labels by using Excel data in a Word mail into word | Excel Discussion (Misc queries) | |||
Printing Word Document using Excel Programming hangs Word | Excel Programming |