TechRepublic|Forums|Software

Software

Question

  • Creator
    Topic
  • July 6, 2007 at 10:46 pm #2269901

    Retrieving data from excel using VB6

    Locked

    by manojgadiyar · about 15 years, 7 months ago

    Hi,
    I am new to vb6.I have just started programming in vb6. Can you please tell me in detail as to how can i retrive data from an excel spread sheet using vb6.

    Thanks,
    manoj

    Topic is locked This conversation is currently closed to new comments.
  • Creator
    Topic

All Answers

  • Author
    Replies
    • July 6, 2007 at 10:46 pm #2600713

      Clarifications

      by manojgadiyar · about 15 years, 7 months ago

      In reply to Retrieving data from excel using VB6

      Clarifications

    • August 21, 2007 at 12:28 am #2628141

      follow this coding

      by kansatheesh · about 15 years, 5 months ago

      In reply to Retrieving data from excel using VB6

      Dim ExcelApp As Excel.Application
      Dim WS As Excel.Worksheet
      Dim i As Integer
      Dim stra As String

      Set ExcelApp = CreateObject(“excel.application”)
      ExcelApp.Workbooks.Open (“C:\txtExce”)’pathname Set WS = ExcelApp.ActiveWorkbook.Sheets(1)

      Dim myVal, myval1 As Variant
      myVal = WS.Range(“a2”).Value
      Debug.Print (IsArray(myVal))
      Text1.Text = myVal
      ‘MsgBox “Value is: ” & myVal
      myval1 = WS.Range(“b2”).Value
      Text2.Text = myval1
      ExcelApp.Quit
      Set WS = Nothing
      Set ExcelApp = Nothing

  • Author
    Replies
Viewing 1 reply thread