Thanks, I'll have a look.
Laurie
On 15 October 2014 15:35, Tracy Pearson <[email protected]> wrote:
> Laurie Alvey wrote on 2014-10-15:
> > I want to bind to Excel so that I know when someone closes it. As I
> could
> > not find a bindable interface supporting the Quit() method, I created a
> > class implementing the WorkbookActivate and WorkbookDeActivate methods,
> > which, while not exactly what I wanted, should be OK for automation. The
> > class definition begins thus:
> >
> > DEFINE CLASS XLAppEvents AS session OLEPUBLIC IMPLEMENTS AppEvents IN
> > "c:\program files\microsoft office\office12\excel.exe" *!* IMPLEMENTS
> > AppEvents IN {00024413-0000-0000-C000-000000000046}
> >
> > The object gets created OK using the above but if I try to use the
> > commented line with the interface ID it throws an error "Type library
> > {00024413-0000-0000-C000-000000000046} is not found." I've searched the
> > registry and the value is there.
> >
> > Anyone got any ideas or suggestions?
> >
> > Laurie
> >
>
> Laurie,
>
> Track back through the TypeLib to find the ProgID in the registry and use
> that in your code instead of the Interface GUID.
> On my machine the first one I found is "Excel.Sheet.8". You might be able
> to
> find others that make more sense.
>
> HTH,
> Tracy
>
>
>
> Tracy Pearson
> PowerChurch Software
>
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/camvtr9epom1nxj75cqnfrptsedrcp4o+8wnrzqcasnopbj_...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
