Is there a method to know something about the parent of an embeded excel?
G Gary''s Student May 10, 2007 #2 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)
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)
