We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
'test for valid OLEobject - linked word doc bFound = False For Each oOLEobj In ActiveSheet.OLEObjects If oOLEobj.Name = "LinkedWordDoc1" Then bFound = True Exit For End If Next 'display associated word doc If bFound Then ActiveSheet.OLEObjects("LinkedWordDoc1").SourceName = "Word.Document.12|" & sWordDoc & "!'" Else 'recreate OLE object With ActiveSheet.Shapes.Range(Array("LinkedWordDoc1")) 'THIS IS WHERE THE PROBLEM IS!!!!!!! End With End If
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Excel 2007 Random Generate List Based on Defined Source Cells||3||27|
|how can I erase a line of text within Microsoft Excel 2013 and replace it with something else?||4||26|
|VBA how to delete all objects regardless of its type from all worksheets in workbook||5||17|
|Modifying VBA to exclude a single row of data when extracted to another workbook||7||11|
Join the community of 500,000 technology professionals and ask your questions.