View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ormy
 
Posts: n/a
Default how to suppress office assistance dialog

I have dts package which will open excel file in order to get data from excel
and load into SQL Server database. Currently, some of excel files prompt
message telling me that office assistance is not installed and wait for an
answer about installation.
How can I suppress this kind of message? I've already add
excelapp.displayalerts = false into my Stored procedure code.

Thank you