Help!

Excel Add-In fails when Worksheet inserted in Word document

 
  

Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Excel General (archive) RSS
Next:  Inserting signature files  
Author Message
OzzieJef



Joined: Oct 02, 2008
Posts: 2



PostPosted: Fri Oct 03, 2008 1:14 am    Post subject: Excel Add-In fails when Worksheet inserted in Word document

I have written an Add-In for Excel, Outlook & Word - well, 3 separate, very similar ones.

Now I have a hiccup. A user decided to insert an Excel Worksheet object into a Word document and my Excel Add-In fell over. It tried to change either a command bar or the DisplayAlerts property in Excel (which depends on version) and the inserted object doesn't have/allow the bar/property.

Is there an particular Excel application property I can test to see if the Add-In should load or not? So far I have found a difference in the Application.MenuBars(7).Menus(1).MenuItems(3).Caption and the Application.MenuBars(7).Menus(1).MenuItems(5).Caption. If Excel is loaded as an insert the first changes from "&Close" to "&Close && Return to Document1" and the latter changes from "&Save" to "Upda&te". My concern is that I am relying on a menu option caption and I think that is not the safest and most reliable test.

What have others used?

Ozzie Jef.
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Excel General (archive) All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum