Results 1 to 2 of 2

Thread: Setting cell values in Excel with VB

  1. #1

    Thread Starter
    New Member
    Join Date
    Jan 2000
    Location
    Albany, OR, United States
    Posts
    10
    I'm trying to set cell values in Excel from within my VB program. If that is possible, how can I do it?
    Any help would be much appreciated.
    Thank you

  2. #2
    Addicted Member
    Join Date
    Aug 1999
    Location
    Hamilton, New Zealand
    Posts
    137
    First create a reference to the Excel Object Library

    Then in your code create the object

    Code:
    Dim xlsApp As New Excel.Application
    Now you can use the object browser to find out all about the properties / methods etc. available through the excel object.

    Regards




    Regards

    Matt Brown
    Hamilton, NZ
    VB6 C++ in Visual Studio 6sp4
    VB.net Beta 1

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