Problem with Excel Automation

[miztaken]

Hi there,

I need to do excel automation.
Basically i need to extract embedded office files (DOC,XLS,PPT)
contained inside Office Files(DOC,XLS,PPT).
In the process i having problem automating Excel Files.
The error i receive when i try to create excel application is:-

1. Error: Exception from HRESULT: 0x800A03EC
2. Error: Call was rejected by callee. (Exception from HRESULT:
0x80010001 (RPC_E_CALL_REJECTED))
these errors are so unpredictable..

After googling i came to the following solution for Error 2
http://msdn.microsoft.com/en-us/library/ms228772(VS.80).aspx
But the code in that link makes my Application Visual Studio dependent
as it requires to open an instance of Visual Studio.

Can anyone help me with this?

Thank You
miztaken

 

[ZSvedic]

Hi there,

I need to do excel automation.
Basically i need to extract embedded office files (DOC,XLS,PPT)
contained inside Office Files(DOC,XLS,PPT).
In the process i having problem automating Excel Files.
The error i receive when i try to create excel application is:-

1.  Error:  Exception from HRESULT: 0x800A03EC
2.  Error:  Call was rejected by callee. (Exception from HRESULT:
0x80010001 (RPC_E_CALL_REJECTED))
these errors are so unpredictable..

After googling i came to the following solution for Error 2http://msdn.microsoft.com/en-us/library/ms228772(VS.80).aspx
But the code in that link makes my Application Visual Studio dependent
as it requires to open an instance of Visual Studio.

Can anyone help me with this?

Thank You
miztaken

Hi,

I doubt that article you are mentioning can help you, it talks about
Visual Studio automation errors, not Office automation errors.

Besides the issue you have, there are few other problems with office
automation you should be aware of:
http://www.gemboxsoftware.com/GBSpreadsheet.htm#Automation

You can use our GemBox.CompoundFile .NET component to extract embedded
office files (DOC, XLS, PPT) contained inside other office files. You
can download Free version or Compound Document Viewer which has export
button:
http://www.gemboxsoftware.com/CompoundFile.htm

This help page explains how to extract embedded office files
programmatically:
http://www.gemboxsoftware.com/CFHelp/GemBox.CompoundFile.Ole2Storage.Export_overload_2.html
It says it doesn't work for PPT, but in the meantime we released a
quick fix which solves that.

-- Zeljko