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.Application")

When that use to work with previous version of Excel, here I have a
error message saying something like Err -2147221231, Err Automation
ClassFactory can't provide the requested class

ANY IDEA :eek

--
freddybe
-----------------------------------------------------------------------
freddybee's Profile: http://www.excelforum.com/member.php...fo&userid=1598
View this thread: http://www.excelforum.com/showthread.php?threadid=27555