Open embedded object problem

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA to open .pdf file embedded in XL W/S 0
Making a sound on condition of textbox 4
How to delete embedded Word object? 3
How can I programatically change the caption on a button? 3
Need Help with Run-time error 5
Opening a Word Document from Excel - ??Stumped?? 1
Embeded Wav 4
Opening a PDF from an Excel User Form 2

Top