worksheet embeded ?

[Milos]

Hi i am using excel 2000 - 2003. I dont know hot to determine if workbook
opened in my instance of excel application is normal opened excel file or if
it was opened from (from example) word document where was embeded (embedded
excel worksheet in word document) by verb OPEN.

I need to distinguish betwen normal opened excel workbook (from file or
blank) and workbook opened from applications where excel sheet was embeded.

ok i complicated.............

i try worksheet.container but didnt work.......may be because an embedded
worksheet is not workbook in excel....

 

[Tom Ogilvy]

This isn't something I have tried to determine, but perhaps the parent
property or the application.usercontrol property. Also, there are some
attributes in commandbars that are used to control menus in this situation,
so there may be an attribute in the office library that you can examine.