ExcelBanter - Parent of the embeded excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Parent of the embeded excel (https://www.excelbanter.com/excel-discussion-misc-queries/142226-parent-embeded-excel.html)

ARHangel

Parent of the embeded excel

Is there a method to know something about the parent of an embeded excel?

Gary''s Student

Parent of the embeded excel

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)
--
Gary''s Student - gsnu200720

All times are GMT +1. The time now is 02:53 PM.