Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Excel events handling

by esr (Scribe)
on Dec 23, 2004 at 05:57 UTC ( #417002=perlquestion: print w/replies, xml ) Need Help??
esr has asked for the wisdom of the Perl Monks concerning the following question:

Is it possible to trap Excel events in Perl code? I have not found much on the Web about Excel events-handling code in Perl except one item posted in 1998 which says that Win32::OLE can't handle them. Has that changed? Are there other modules that might make this possible? Any pointers to info on how to write such a beast?

Replies are listed 'Best First'.
Re: Excel events handling
by olivierp (Hermit) on Dec 23, 2004 at 08:17 UTC
    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
      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
Re: Excel events handling
by sasikumar (Monk) on Dec 23, 2004 at 06:58 UTC

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://417002]
Approved by monkfan
help
Chatterbox?
[1nickt]: Ah, I see. I did read some gamer mag reviews, and yes, they lamented the fact that laptops with no discrete video card are sold as "gaming" hardware.
[1nickt]: But, they do have red keyboard backlighting! And gargoyles on the front, or words like "Maxxx" here and there. They know their demographic!
[1nickt]: True gamers don;t buy Dells, HPs, or Lenovos, I think ;-)
[ambrus]: The keyboard I bought doesn't have backlighting. I specifically had to select for that, because so many keyboards these days have lights. Why would I want lights in the keyboard? I want lights in the room, such as on the ceiling, not in the keyboard.
choroba has a small USB lamp
[ww]: ++ all (phony labels re "gaming"
[1nickt]: ambrus perhaps you know where the keys are?

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (11)
As of 2017-03-27 13:47 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Should Pluto Get Its Planethood Back?



    Results (320 votes). Check out past polls.