LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.dotnet.languages.vb,microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Process excel files, suppress alerts

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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatic alerts in excel PK Excel Discussion (Misc queries) 3 April 26th 08 04:57 PM
How Excel VBA corporate with MSN Alerts? jazzcarr Excel Discussion (Misc queries) 0 January 1st 08 12:37 PM
Settings for pop up alerts in excel Victor Excel Discussion (Misc queries) 2 July 27th 07 08:52 PM
how do i set up sound alerts on excel? Anuj Dhamija Excel Discussion (Misc queries) 1 May 19th 06 02:26 PM
Suppress protection alerts in Excel Yohanne the Great Excel Discussion (Misc queries) 5 March 5th 06 10:06 PM


All times are GMT +1. The time now is 03:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"