View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Haim[_3_] Haim[_3_] is offline
external usenet poster
 
Posts: 2
Default run time error when inserting Excel sheet into word document

Hello

I am using a tool bar (add-in) in my Excel application. The add-in projects
are protected and you can access the code only with a password that I have.
When I am using the add-in in Excel everything works perfectly fine. When I
tried to insert Excel sheet object into MS Word, I can see add-in and I can
use its functionality but in some of the operations I am getting Excel
runtime errors. I thought that the issue is with the password protected files
but I am getting the same errors even after I removed the protection and I
unlocked the files. When I pressed the "Debug" button and stepped into the
code I saw that the problem is in the Excel "Application" object. when the
code try to access this object (i.e. Application.Calculate) it fails. Is
anyone know how to solve this problem? I tried to the same in PowerPoint and
I got the same errors.

Thanks :-(

Haim