Thread: Excel and Word
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
freddybee freddybee is offline
external usenet poster
 
Posts: 1
Default 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