Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Controlling Msgboxes (XP;SR2)

    I use an XL Essbase add-in to load data to a database and then calculate the database. All this is done via code and works quite well. After the database is calculated a message box is returned informing the user that the calculation was successful. To clear to message box one has to click on "Ok". My question is how to programatically respond to the message box. Inserting Application.DisplayAlerts = False does not do the trick.

    Thanks,
    John

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Controlling Msgboxes (XP;SR2)

    You could try:
    <pre>Sendkeys {ENTER}</pre>


    But I am not overly confident. I have the feeling it will wait to send the keys until after the msgbox goes away.

    If you can edit the addin code, you could modify the code or the other alternative is to write to techsupport for the addin. The addin programmer added that msgbox, and they would have to remove it from the code if you are not allowed to edit it.

    Steve

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Controlling Msgboxes (XP;SR2)

    Steve,

    SendKeys did not work. I did make an inquiry to the techsupport for Essbase prior to making my post in the Lounge. Unfortunately it is the weekend; it will have to wait until Monday.

    I thought that there was a slim chance of taking control over the addin message box.

    Thanks,
    John

  4. #4
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Controlling Msgboxes (XP;SR2)

    Hi,

    Try this code. It displays a message and closes after about 3 seconds!

    Sub PopupMsg()
    CreateObject("WScript.Shell").Popup "Type message here!", 3, "Actions Completed"
    End Sub
    Regards,
    Rudi

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •