CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2001
    Posts
    15

    Accessing Excel from VB

    Hi,
    I would like to know a few things regarding usage of Excel in VB.
    Presently I am working in office 2000 on windows 95 platform. In the references, I am able to see the Excel 9.0 and Excel 5.0 object libraries.When I install Office 97, I am able to see only Excel 8.0 object library.
    If i use Excel 8.0 object library in my application will it be compatible with office 2000(Excel 9.0 object library) also?


  2. #2
    Join Date
    Jul 2000
    Location
    Milano, Italy
    Posts
    7,726

    Re: Accessing Excel from VB

    If using 8.0 to read/write excel sheet, you may find it will work until opening the xls with excel2000. After that, you may not be able to open, read or write it again using your Vb (excel8.0) application, unless you save it each time with previous version via excel.

    Special thanks to Lothar "the Great" Haensler, Tom Archer, Chris Eastwood, TCartwright, Bruno Paris, Dr_Micahel
    and all the other wonderful people who made and make Codeguru a great place.
    Come back soon, you Gurus.

    The Rater
    ...at present time, using mainly Net 4.0, Vs 2010



    Special thanks to Lothar "the Great" Haensler, Chris Eastwood , dr_Michael, ClearCode, Iouri and
    all the other wonderful people who made and make Codeguru a great place.
    Come back soon, you Gurus.

Posting Permissions

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





Click Here to Expand Forum to Full Width

Featured