Search

Software

Question

Gravatar
Locked

Retrieving data from excel using VB6

By manojgadiyar ·
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

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
+ Follow this Discussion ·
| Thread display: Collapse - | Expand +

All Answers

gravatar
Collapse -

follow this coding

by kansatheesh In reply to Retrieving data from exce ...

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

Back to Software Forum
2 total posts (Page 1 of 1)  

Start or search

Related Discussions

Related Forums