Parent of the embeded excel

G

Guest

Sub test()
MsgBox Selection.Address
MsgBox Selection.Parent.Name
MsgBox Selection.Parent.Parent.Name
End Sub


The last Msgbox will return the Workbook name (mon-embedded) or
the enclosing Word doc name & path ( embedded)
 

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

Issue is facing on Word 2016 -{EMBEDED Excel.Sheet.12} 0
How to turn off "print both sides"? 2
embeded excel control doesn't work properly if excel workbook is open through GetObject("xx.xls") 2
Embeded excel's parent 5
sub forms in excel? 7
Getting embeded Excel worksheets with macros in Word to work 2
Protecting an Excel worksheet without locking the embedded scrollbar 4
Emebed worksheet not able to see whole worksheet 4

Top