ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   worksheet embeded ? (https://www.excelbanter.com/excel-programming/320188-worksheet-embeded.html)

Milos

worksheet embeded ?
 
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

worksheet embeded ?
 
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.

--
Regards,
Tom Ogilvy

"Milos" wrote in message
...
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....






All times are GMT +1. The time now is 11:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com