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

Answer 1

T-SQL question? Wrong forum?

---

Erland Sommarskog, SQL Server MVP, [e-mail]

Answer 2

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

Answer 3

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

Answer 4

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