Welcome to Forums Sign in | Join | Help | Forums
in Search





Make the world a better place.

Use of REApplication object in VBA

Last post 11-30-2008 7:45 PM by Nigel Henriques. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 11-24-2008 1:37 PM

    Use of REApplication object in VBA

    Hi ... Has anyone tried to use the REApplication object and specifically writing code for the UIOpening and UIClosing events ? The vba documentation (admittedly limitted) suggests that VB code can be written to execute code when the user starts up a Raisers Edge session. I would like to take advantage of this, but do not have any examples for the event subroutine calls.

    Thx Nigel

    Filed under: ,
  • 11-26-2008 5:38 AM In reply to

    • David Zeidman
    • Top 25 Contributor
    • User Since: 2002
    • Posts 205
    • Organization: Zeidman Development
    • Products:  Blackbaud Direct Marketing, Blackbaud Enterprise CRM, The Information Edge, The Raiser's Edge

    Re: Use of REApplication object in VBA

     It is possible to access these events by in the VBA environment, under the system project, going to RE7 objects and selecting REApplication. Then in the code window select REApplication and by default the event:

    Private Sub REApplication_UIClosing(bCancel As Boolean)

    End Sub

    appears. You can select the UIOpening one from the drop down. These will then fire on opening and closing of RE

     

    David

    David Zeidman
    Zeidman Development
    http://www.zeidman.info

    Check out my RE API blog
    http://www.re-decoded.com
  • 11-30-2008 7:45 PM In reply to

    Re: Use of REApplication object in VBA

    Thanks David,

    Yes, I managed to successfully use both the UIOpening and UIClosing. In our particular application, I have used the UIOpening to identify the database we are working against (non-production, live, etc.).

     Thanks

     

Page 1 of 1 (3 items)