Open embedded object problem

  • Thread starter Thread starter Pete
  • Start date Start date
P

Pete

Hi.

I am trying to open embedded word objects in a excel book using the
following code generated using the macro recorder.

Sub OE9()
Sheets("OE PLans").Select
ActiveSheet.Shapes("Object 9").Select
Selection.Verb Verb:=xlPrimary
End Sub

The code works fine however when I try and close the workbook it tells me
there is a sharing violation, prompts me to save as another name but then
tells me the document is not saved.

Can anyone please advise why or offer another solution to open the embedded
documents using code.

Thanks
Pete
 
Back
Top