Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run-time error '-2147221080 (800401a8)': Automation error | Excel Programming | |||
Compile error: Automation error in Excel 97 | Excel Programming | |||
Urgent!!! Run-time error '-2147024770 (8007007e)' Automation error | Excel Programming | |||
Run-Time Error'-2147221080(800401a8)': Automation Error | Excel Programming | |||
Unknown where is the problem on the Runtime error - Automation error | Excel Programming |