Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

Re: Excel events handling

by olivierp (Hermit)
on Dec 23, 2004 at 08:17 UTC ( #417024=note: print w/ replies, xml ) Need Help??


in reply to Excel events handling

I did have this around somewhere... with Outlook / Exchange, but a quick check in the Win32::OLE docs suggests it is possible. Have a look at Win32::OLE qw (EVENTS).
If I find the beast, I'll update this. Update:While XP is searching my disks, I've found this on Dave Roth's site. It may help you get started.

HTH
--
Olivier


Comment on Re: Excel events handling
Re^2: Excel events handling
by olivierp (Hermit) on Dec 23, 2004 at 14:21 UTC
    I did find it, and updated it somewhat.
    This has been tested against Excel 2002 sp3, on XP
    Note that this script will leave dangling Excel processes in memory if given the chance, and will not end if you manually close Excel while it is running.
    As usual with these things, ActiveState's OLE browser comes in handy, as well as the documentation for Excel's Object model. In particular for identifying the arguments your event handler(s) can potentially receive.
    HTH
    --
    Olivier

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://417024]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others rifling through the Monastery: (7)
As of 2014-11-27 18:29 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My preferred Perl binaries come from:














    Results (186 votes), past polls