Automation error for proecssing few xla files
 

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

Automation error for proecssing few xla files
 

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

"Sachin" wrote in message
...
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

Automation error for proecssing few xla files
 

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

"Patrick Molloy" wrote:

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

"Sachin" wrote in message
...
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

Automation error for proecssing few xla files
 

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

"Sachin" wrote:


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

"Patrick Molloy" wrote:

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

"Sachin" wrote in message
...
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