none
How to show up a Excel Application which Application.visible=false? RRS feed

  • Question

  • I been draw out a VB program that could auto run by Windows tasker,

    The VB program will open the excel files which with Workbook_open events to follow the action,

    But once the program communicate with SQL server with errors,

    I can't re-get the application, which the application.visible=false been set.

    How could I re-get the application by application handler no. or any else?

    Any reply will be much appreciated.

    Thursday, March 29, 2018 11:48 PM

All replies

  • Hi iEric,

    Thanks for posting in our forum. Then here we mainly focus on general issues about Office client. Since your query is more related to VB program, I'll move your thread to the following dedicated MSDN forum for Excel for better response:

    https://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

    Regards,

    Yuki Sun


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Friday, March 30, 2018 3:06 AM
  • Hello iEric Hu,

    What do you mean re-getting the application? If you want to continue to handle the created application in other method/function. You could dim the application as an global variable so you could access it wherever in your project.

    Besides, you could also try to get an application instance using GetObject("Excel.Application").

    Best Regards,

    Terry


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Friday, March 30, 2018 7:38 AM