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.

"Sachin" <(E-Mail Removed)> wrote in message
news:1D7DCAAC-A180-4351-B091-(E-Mail Removed)...
> 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

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" <(E-Mail Removed)> wrote in message
> news:1D7DCAAC-A180-4351-B091-(E-Mail Removed)...
> > 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
>

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" <(E-Mail Removed)> wrote in message
> > news:1D7DCAAC-A180-4351-B091-(E-Mail Removed)...
> > > 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
> >