Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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....


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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....




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Embeded IF - between ranges Emily Excel Worksheet Functions 2 January 14th 10 11:23 PM
Embeded IF Statement Rob M Excel Worksheet Functions 2 December 7th 07 02:24 PM
More than 7 embeded if statements Jcraig713 Excel Worksheet Functions 1 November 21st 07 03:33 PM
Embeded ComboBox ed Excel Worksheet Functions 1 November 13th 07 08:15 PM
How to to catch embeded worksheet events in a host program (Access in my case) ? Patrice Ongla Excel Programming 0 July 27th 03 05:52 PM


All times are GMT +1. The time now is 04:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"