Automation error for proecssing few xla files

[Sachin]

hi
i am trying to process xla file using C# interops
For a perticular file i am facing a problem when i tried open the file it
throws an error window "opening the VBA project in this file requires a
component that is not currently installed. This file will be opened without
VBA project"

for other few files i get error window "hlib32.dll file not found"

Does any have an idea what could be the reason .

What is the best way to avoid such pop up windows coming because i want to
run the program unattended by user .

Thanks in advance
Sachin

 

[Patrick Molloy]

presume you're instantiating excel first. you could try running
Application.DisplayAlerts = False
but I don't know about that dll issue, sorry.

 

[Sachin]

i have tried display alert setting false but that does not help

excelApplication = new Microsoft.Office.Interop.Excel.ApplicationClass();
excelApplication.DisplayAlerts = false;
excelApplication.DisplayClipboardWindow = false;

may be there any any pther work around to get rid of this window ..

sachin

 

[Sachin]

the work around could be while opening the excel workbook objEditable is
set to true instead of false ..