none
how to hide excel save dialog box in VB script under SSIS

    Question

  • Anyone know how to prevent Excel 2007 from displaying the Opening progress dialog (with the cancel button on it) when opening a big spreadsheet using VB Script.  I tried to Displayalerts set it to False would do it, but no luck. I tried making Excel invisible during the open as well but no improvement. Even I tried to give below mentioned code but no luck. 

    appExcel.enableevents = False
    appExcel.DisplayAlerts = False
    appExcel.visible = False

    Could any one please help me to solve this issue. 



    Shailesh

    • Moved by Naomi N Tuesday, January 08, 2013 1:01 PM Better answer can be here (From:Transact-SQL)
    Tuesday, January 08, 2013 10:30 AM

All replies

  • T-SQL question? Wrong forum?


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
    Tuesday, January 08, 2013 11:29 AM
  • Are you able to identify what this dialog is doing if you do the same operation manually? 

    For every expert, there is an equal and opposite expert. - Becker's Law


    My blog

    Tuesday, January 08, 2013 1:01 PM
  • Anyone know how to prevent Excel 2007 from displaying the Opening progress dialog (with the cancel button on it) when opening a big spreadsheet using VB Script.  I tried to Displayalerts set it to False would do it, but no luck. I tried making Excel invisible during the open as well but no improvement. Even I tried to give below mentioned code but no luck. 

    appExcel.enableevents = False
    appExcel.DisplayAlerts = False
    appExcel.visible = False

    Could any one please help me to solve this issue. 



    Shailesh

    Hi Shailesh21,

    the code: "appExcel.DisplayAlerts = False"

    is perfect to hide excel save dialog box. If you have problem tried to post all the code


    Ruggiero Lovreglio
    www.ruggierolovreglio.altervista.org

    Tuesday, January 08, 2013 3:01 PM
  • Look at the full syntax of Open method and you may want to set UpdateLinks property

    http://msdn.microsoft.com/en-us/library/office/ff194819.aspx

    Also check

    Excel.EnableEvents

    and/or

    Excel.UserControl


    For every expert, there is an equal and opposite expert. - Becker's Law


    My blog


    • Edited by Naomi N Tuesday, January 08, 2013 3:50 PM
    Tuesday, January 08, 2013 3:49 PM