Many thanks Simon. I set the UpdateLinks property to false and it worked
without any problem.

Kind regards

--
Wazir



"Simon Murphy" wrote in message
...
Wazir
Update links is an argument of the workbooks.open method.
I generally open stuff without updating links and readonly:
workbooks.open "wbname", false, true
(if you are using vb.net you can use named arguments)
You may want to turn macros off too (Only available in XP
or better)
Cheers
Simon

-----Original Message-----
Dear all,

I have a .NET app that processes some excel file and it
was working in all
scenarios.

Recently however we received excel files from a new
client which my
application has been unable to process. The problem is
that this file has
external links and when you open the excel file, it
prompts you to either
update linked information or keep exisiting information.

Since my application runs in a non UI mode, there is no
way for me to
respond to this request. I have tried suppressing these
message boxes but
have been unable to do so.

I have tried the following to no avail

oExcel.Visible = False
oExcel.AlertBeforeOverwriting = False
oExcel.DisplayAlerts = False

I will be greatful for any pointers in this regard.

Many thanks,

--
Wazir



.