Click here to Skip to main content
15,878,748 members
Articles / Programming Languages / C#

Opening and Navigating Excel with C# - Removing dialogs

Rate me:
Please Sign up or sign in to vote.
3.50/5 (3 votes)
26 Mar 2009CPOL 25.1K   12   1
Remove dialogs

Introduction

Take a look at the article below first. The only thing I'm adding here is how to remove dialogs... since I couldn't find that anywhere online.

Code

Error: The problem is that every time I run it, a message box comes up saying: "'example.xls' is being modified by johndoe. Open as read-only?"

Solution:

Before opening the Excel file, run this code:

C#
excelApp.DisplayAlerts = false;

So, the entire code would look like this:

C#
Microsoft.Office.Interop.Excel.Workbook workbook;

Microsoft.Office.Interop.Excel.ApplicationClass excelApp = 
          new Microsoft.Office.Interop.Excel.ApplicationClass();

excelApp.DisplayAlerts = false;

workbook = excelApp.Workbooks.Open(   
    filename,
    ExcelLib.XlUpdateLinks.xlUpdateLinksAlways, 
    ReadOnly, 5, Type.Missing, Type.Missing, true,
    ExcelLib.XlPlatform.xlWindows, Type.Missing, 
    true, false, Type.Missing, false, false,
    ExcelLib.XlCorruptLoad.xlNormalLoad 
);

And that's all I wanted to add. (Note, the linked article isn't allowing me to post, otherwise I'd have thrown a message up there on it.)

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Software Developer
United States United States
likes boardgames, computer games, and enjoys his .net programming job.

Comments and Discussions

 
GeneralReason you couldn't post a message to the linked article Pin
Kent K31-Mar-09 8:09
professionalKent K31-Mar-09 8:09 
. . .I think was probably just the URL you came into it with. . .you probably found it by a yahoo or google search?

You get a different view sometimes with arrivals via search engines. If you search for that article at codeproject you will get this url, a different one but one that you could post a message to. Opening and Navigating Excel with C#[^]

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.