Automation error for proecssing few xla files

  • Thread starter Thread starter Sachin
  • Start date Start date
S

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
 
presume you're instantiating excel first. you could try running
Application.DisplayAlerts = False
but I don't know about that dll issue, sorry.
 
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
 
the work around could be while opening the excel workbook objEditable is
set to true instead of false ..
 
Back
Top