Excel and Word

[freddybee]

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

 

[Dick Kusleika]

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(...)