Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Implementing Excel events
Message
 
 
To
02/10/2009 04:35:43
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01427263
Message ID:
01427279
Views:
50
Denis,

Try
IMPLEMENTS AppEvents IN {00020813-0000-0000-C000-000000000046}#1.6
>I need to handle Workbook Save event to protect the workbook with password.
>I can't find the way to implement event for Eventhandler
>
>In the object browser I can open COM class
>Library Excel
>Microsoft Excel 12.0 Object Library
>File: c:\programme\microsoft office\office12\excel.exe
>GUID: {00020813-0000-0000-C000-000000000046}
>
>When I drag and drop interface workbook into program I'v got some code like
>
>DEFINE CLASS myclass AS session OLEPUBLIC
> IMPLEMENTS _Workbook IN "Excel.Workbook"
>
>when I start it - error happens "Type Library Excel.Workbook not found "
>
>Ok. then I change it to
>
>DEFINE CLASS myclass AS session OLEPUBLIC
> IMPLEMENTS _Workbook IN "c:\programme\microsoft office\office12\excel.exe"
>
>it works!!! but the problem - I can't use static path in the application!.. when I change to IN "Excel.Application" or use CLSID - same problem with Type library not found
>
>Any ideas!
>Thanks
>Denis
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform