> > Behavior is I get the message when the editor is created, but nothing > > when it is destroyed. I've also been unsuccessful with other > > variations: using win.class; win.exename; using a separate button to > > see if the editor window is present ... > > Basically your script is correct, but seems a bit redundant: > > if(win.caption(arg(2))=="Microsoft Visual Basic - Personal Macro > workbook.xls")do > if(arg(1)==3) > message "Hello VBE" > if(arg(1)==4) > message "goodbye VBE" > endif >
The above shoudl work if the vbe window is cooperative. But sometimes the caption does not work if the window changes it before it exits. Since you can find the window at the start, try saving its handle then and using it later. static vbe_handle if(arg(1)==3 && win.caption(arg(2))=="Microsoft Visual Basic - Personal Macro workbook.xls")do vbe_handle=arg(2) message "Hello VBE" endif if (arg(1)==4 && arg(2)==vbe_handle) do vbe_handle=0 message "goodbye VBE" endif > > Attention: PowerPro's Web site has moved: http://www.ppro.org Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/power-pro/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
