Microsoft Word doesnt convert ole objects

Question

Dear support team,

we have the following issue and hope we found the right place to ask.

In one of our analitical applications a report is generated in a word file format. This word file has also embedded excel tables as OLE objects as far as we see.

The problem is that the report is generated in a new Word version, but does not auto-detect Excel 2003 OLE objects which are the tables inside. We always need to manually convert them to Excell 2003 as a workarround which is time consuming.

We are using the following script in the macro :

Sub ConvertOleObjs()

Application.ScreenUpdating = False

Dim i As Long

With ActiveDocument

 For i = .InlineShapes.Count To 1 Step -1

   With .InlineShapes(i)

     If Not .OLEFormat Is Nothing Then

       If .OLEFormat.ClassType = "Excel.Sheet.12" Then

         .OLEFormat.ConvertTo "Excel.Sheet.8"

       End If

     End If

   End With

 Next

End With

Application.ScreenUpdating = True

MsgBox "Finished processing!"

End Sub

Could you please help with resolving the issue

Regards

Answer 1

Dear Todorova Maya,

Thanks for your reply. Sure, you could contact the Microsoft 365 administrator and follow the steps outlined in this article to create a support ticket and contact Online Support.

The support team at Online Support has higher permissions than us and can remotely examine the situation on your end, gather more resources, and assist you with troubleshooting. This will be a more efficient way to address your concerns.

Thank you for your understanding and cooperation! Have a great day.

Sincerely,

Sean | Microsoft Community Moderator

Answer 2

Dear Sean,

I think there is a misunderstanding about the problem. This is a bug in your product apparently. The new Word version doesnt recognise old Excel objects.

The VBA code is a workarround, I do not have an issue with it, but we expect the Word to do this automatically.

Could you please let us know if there is any real support , like open an incident etc. for Microsoft and not only forums?

Thank you very much in advance

Maya Todorova

Answer 3

Dear Todorova Maya,

Thanks for posting in Microsoft Community. 

We would love to help you with your query about VBA code, however, our team focuses on general queries, for example, installation and activation issues of Office 365 products. The situation you mentioned is related to VBA code, you can refer to this article: Office VBA support and feedback | Microsoft Docs to go to Stack Overflow by using the VBA tag, along with any other relevant tags as there are also many experienced engineers and experts in the forums there. 

Disclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites, or any support related to technology.

At the same time, we will also keep this thread open, so other Community members and Experts can also share their suggestions and inputs. 

Have a nice day and keep safe.

Sincerely,

Sean | Microsoft Community Moderator