bradyboyy88
Well-known Member
- Joined
- Feb 25, 2015
- Messages
- 562
So I embed some word documents in a excel sheet. The problem is when I go to save it says errors were detected while savings blah .xlsm. Microsoft may be able to save the file by removing or repairing some features. To make repairs in a new file, click continue. To cancel saving blah blah blah. It never actually works for the repairs and I cannot save.
The code I used to add the objects is as follows:
It is apart of a loop and it inserts each of these objects as a icon down the columns. I checked and they all open fine its just a matter of saving that I cannot do. If there is a fix to this then some help would be appreciated!
The code I used to add the objects is as follows:
Code:
If Worksheets("Search Interface").Shapes("EmbedCheckBox").ControlFormat.Value = 1 Then
.OLEObjects.Add Filename:=File.Path, Link:=False, DisplayAsIcon:=True, Left:=.Range("D" & PrintRow).Left + 30, Top:=.Range("D" & PrintRow).Top + 3, Width:=50, Height:=10
End If
It is apart of a loop and it inserts each of these objects as a icon down the columns. I checked and they all open fine its just a matter of saving that I cannot do. If there is a fix to this then some help would be appreciated!