0x800706BA RPC server Excel Addshape

[Olivier57]

Hi,

I wrote an Excel utility with VB .net 2008 standard and Excel 2003.

The purpose of this tool is to complete information in 700 Excel files
- copy 2 models sheets
- add about 150 names from a model file
- draw from 0 to 200 oval shapes in the resulting file

The application works "ok" but after 15 to 20 mn, stops at different points
after Excel calls (open, get value from named range...) with message "RPC
server unavailable (0x800706BA)."

This happens in debug mode or in runtime mode, on two differents pc.

Can someone help me ?

Thanks s much,

Olivier

 

[Andrei Smolin [Add-in Express]]

Hi Olivier,

Do you close those files after processing them?
Do you have hanging Excel processes in the Task Manager?
Do you create new Excel instances in your code? If yes, do you close them?

Regards from Belarus (GMT+2),

Andrei Smolin
Add-in Express Team Leader
www.add-in-express.com

 

[olivier57]

Hi Andrei

I'm very sorry not to answer earlier, but I haven't be notified of your answer. So I came back here to see if I got new posts.

Your suggestions sounds good but I don't find any situations like these.

I got the same problem with another development and in both case, the problem seems to happen with long treatment, more than 4 to 5 minutes.

Olivier



Posted as a reply to:

Re: 0x800706BA RPC server Excel Addshape

Hi Olivier

Do you close those files after processing them
Do you have hanging Excel processes in the Task Manager
Do you create new Excel instances in your code? If yes, do you close them

Regards from Belarus (GMT+2)

Andrei Smoli
Add-in Express Team Leade
www.add-in-express.co


EggHeadCafe - Software Developer Portal of Choice
WCF Workflow Services Using External Data Exchange
http://www.eggheadcafe.com/tutorial...a-6dafb17b6d74/wcf-workflow-services-usi.aspx