Skip to Main Content
Status Planned
Workspace DX Assets
Created by John Hammond
Created on May 27, 2022

MS Excel VBO - Get Error Message

When running saved Power Queries, a multitude of potential error messages could pop up within Excel. To simplify exception messaging, it would be a great help if we were able to grab these error messages generated by Excel.

  • Neeraj Kumar
    Reply
    |
    Jan 3, 2023

    Thanks Eric for update..

  • Admin
    Eric Wilson
    Reply
    |
    Jan 3, 2023

    Hello Neeraj - No, this has not been delivered yet. It's relatively low in our backlog at the moment. There's no planned delivery date yet.

  • Neeraj Kumar
    Reply
    |
    Jan 2, 2023

    Hello Eric - Please can you confirm if this has been delivered, if not when this is targeted?

  • Admin
    Eric Wilson
    Reply
    |
    Jun 3, 2022

    Thank you for your submission. I think there's something we can do here. There's existing functionality associated with the Run Macro with Parallel Thread action that we may be able to adapt to support this. The general idea is that we launch a separate thread that watches for popu-up dialogs within Excel and then it automatically presses the "OK" button. We'll set up some tests and see how this goes.