I produce a spreadsheet in excel 2003 where there is a macro that exports a named range into a word 2003 document. This works well for someone that has office 2003 or 2007, but it doesn't seem to work for someone using excel 2010.
These users get the following error: Microsoft Visual Basic, Runtime error 1004, Copypicture method of range class failed
This is the beginning of the VBA Code:
Dim wdApp As Word.Application, wdDoc As Word.Document, ws As Worksheet
Application.ScreenUpdating = False
Application.StatusBar = "Creating new document..."
Set wdApp = New Word.Application
Set wdDoc = wdApp.Documents.Add
I know that the Word Object Library in VBE 2003 is 11.0 while it is 14.0 in VBE 2010....could this be the s
ource of the error?
Can this macro code work using a 14.0 Word Object Library?
These users get the following error: Microsoft Visual Basic, Runtime error 1004, Copypicture method of range class failed
This is the beginning of the VBA Code:
Dim wdApp As Word.Application, wdDoc As Word.Document, ws As Worksheet
Application.ScreenUpdating = False
Application.StatusBar = "Creating new document..."
Set wdApp = New Word.Application
Set wdDoc = wdApp.Documents.Add
I know that the Word Object Library in VBE 2003 is 11.0 while it is 14.0 in VBE 2010....could this be the s
ource of the error?
Can this macro code work using a 14.0 Word Object Library?
Last edited: