Process excel files, suppress alerts

[mwazir]

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

[scorpion53061]

> 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.

Try

xlsdoc.Application.DisplayAlerts = False

to address the sheet within the application.

[mwazir]

Hi there,

Thanks for the response. I have already tried DisplayAlerts = False

Simon from the microsoft.public.Excel.programming NG kindly pointed out that
while opening the file UpdateLinks property can be set to False

ie. oExcel.Workbooks.Open (Filename := strFilename, UpdateLinks := False,
ReadOnly := True)

Regards

--
Wazir

"scorpion53061" <sc************@nospamhereeveryahoo.com> wrote in message
news:O7**************@tk2msftngp13.phx.gbl...

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.

Try

xlsdoc.Application.DisplayAlerts = False

to address the sheet within the application.

[scorpion53061]

> Thanks for the response. I have already tried DisplayAlerts = False

Did you try it as I showed you?

[scorpion53061]

> 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.

Please send a sample of this file I can work with to
ad***@nospamkjmsolutions.com

[mwazir]

> Did you try it as I showed you?

I have tried your suggestion before with all sort of combinations I could
think of and I am afraid it did not work for me.

I have tried in the past

1. myWorkbook.Application.DisplayAlert = False
2. myExcel.DisplayAlert = False

3. myWorkbook = myExcel.activeworkbook
myWorkbook.Application.DisplayAlert = False

DisplayAlerts would have no consequence to opening external links as this
MSDN documentation shows:

Here is the MSDN documentation for UpdateLinks.

UpdateLinks Optional Variant
Specifies the way links in the file are updated. If this argument is
omitted, the user is prompted to specify how links will be updated.
Otherwise, this argument is one of the values listed in the following table.

0 Doesn't update any references
1 Updates external references but not remote references
2 Updates remote references but not external references
3 Updates both remote and external references

Unfortunatly for me, until someone pointed out I did not know this feature.

I hope that clarifies the issue,
Thanks for your response.

--
Wazir