Is there anyway with VB.net to force closing of a spreadsheet in E

Discussion in 'ASP .Net' started by =?Utf-8?B?TmVpbA==?=, Apr 15, 2005.

  1. I am updating a spreadsheet from vb.net application.

    I need to see if the specific .xls file is open and force
    closing it before the program updates the spreadhseet using
    ADO.net.

    Is there anyway to see if the spreadsheet (not excel) is open and close it?
     
    =?Utf-8?B?TmVpbA==?=, Apr 15, 2005
    #1
    1. Advertising

  2. =?Utf-8?B?TmVpbA==?=

    Mark Newby Guest

    Re: Is there anyway with VB.net to force closing of a spreadsheetin E

    Neil wrote:
    > I am updating a spreadsheet from vb.net application.
    >
    > I need to see if the specific .xls file is open and force
    > closing it before the program updates the spreadhseet using
    > ADO.net.
    >
    > Is there anyway to see if the spreadsheet (not excel) is open and close it?


    have a look at the object model for an Excel Application. then something
    like ExcelObject.GetCurrentSession.

    perhaps it would be best to ask on an excel newsgroup.
     
    Mark Newby, Apr 27, 2005
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. José Joye

    Is there anyway to detect a F5-Refresh

    José Joye, Jun 27, 2006, in forum: ASP .Net
    Replies:
    2
    Views:
    3,132
    José Joye
    Jun 27, 2006
  2. Vajira

    Is there anyway to iterate STL queue ?

    Vajira, Jan 28, 2005, in forum: C Programming
    Replies:
    3
    Views:
    7,362
    Vajira
    Jan 28, 2005
  3. Frank B.
    Replies:
    11
    Views:
    464
    jmcgill
    Oct 11, 2006
  4. kkappabear
    Replies:
    0
    Views:
    116
    kkappabear
    Dec 12, 2006
  5. SteveM
    Replies:
    5
    Views:
    118
    SteveM
    Dec 7, 2007
Loading...

Share This Page