+ Reply to Thread
Results 1 to 2 of 2

Suppress messages/warnings using Workbooks.Open

  1. #1
    Guy Fawkes
    Guest

    Suppress messages/warnings using Workbooks.Open

    Hi

    I'm writing an automated test using C# and Nunit, that are to open an Excel
    workbook, insert values, call a macro and then check the resulting values in
    a SQL Server table. At present I'm passing a value of 2 to teh Updatelinks
    paramter.

    As this is an automated test, I don't want user interaction.

    The problem I'm having is that there are a few messages that still appear.
    Firstly, one saying that remote data is not accessable which appears to be a
    warning that an application isn't on my PC. I simply want to ignore this
    message. Secondly, the message that the workbook contains links that cannot
    be updated and "Continue" and "Edit Links..." buttons.

    I need these suppressed. Any ideas how?

    Regards



  2. #2
    Bob Phillips
    Guest

    Re: Suppress messages/warnings using Workbooks.Open

    In your code to open the workbook, set the second argument, updatelinks:= 0

    --
    HTH

    Bob Phillips

    (remove xxx from email address if mailing direct)

    "Guy Fawkes" <Guy [email protected]> wrote in message
    news:[email protected]...
    > Hi
    >
    > I'm writing an automated test using C# and Nunit, that are to open an

    Excel
    > workbook, insert values, call a macro and then check the resulting values

    in
    > a SQL Server table. At present I'm passing a value of 2 to teh Updatelinks
    > paramter.
    >
    > As this is an automated test, I don't want user interaction.
    >
    > The problem I'm having is that there are a few messages that still appear.
    > Firstly, one saying that remote data is not accessable which appears to be

    a
    > warning that an application isn't on my PC. I simply want to ignore this
    > message. Secondly, the message that the workbook contains links that

    cannot
    > be updated and "Continue" and "Edit Links..." buttons.
    >
    > I need these suppressed. Any ideas how?
    >
    > Regards
    >
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1