I am trying to modify embedded excel object in Word from another Excel document with VBA. But I get one error about it. I have searched a lot, I have find some solutions which didnt resolve my problem.
I have already tried these :
MS Office Diagnostics and no errors were reported.
"Repaired" the installation from add/remove programs.
converting the embedding object to a binary object and back again.
...
When I call " oOleFormat.Active" in source code like below, I get this error:
Run Time Error 6069 :
The program used to create this object is excel. that program is not installed on your computer. To edit this object, install Excel or ensure that any dialog boxes in Excel are closed.
Source Codes
Dim embObject As Excel.Workbook
Dim oWorksheet As Excel.Worksheet
Dim oOleFormat As Word.oleFormat
Dim oRange As Excel.Range
Dim dataArray() As String
If (table.Range.InlineShapes.count <> 0) Then
'Access Object
Set oOleFormat = table.Range.InlineShapes.item(1).oleFormat
oOleFormat.Activate
Set embObject = oOleFormat.Object`
