How to read excel sheet through v.b 6.0

[raghunadhs]

Hi every body!

I would like to develope an application. it should read data from existed excel sheet.besides this we can able to modify some of data in the excel sheets through our v.b application. it is urgent to me. can u say how to do it? and what controls are to be used.Actually i knew to v.b. kindly help me.
thank u:
regards:
raghunadhs

[Dököll]

Hi every body!

I would like to develope an application. it should read data from existed excel sheet.besides this we can able to modify some of data in the excel sheets through our v.b application. it is urgent to me. can u say how to do it? and what controls are to be used.Actually i knew to v.b. kindly help me.
thank u:
regards:
raghunadhs

Greetings, raghunadhs!

Please excuse my passiveness. I think you will find posts hre that deal with what you need, posted just recently.

I would add your title to search terms here, see what pops up. How's that for deal?

[raghunadhs]

I could not get any reply for this thread. if u know kindly help me
regards:
Raghunadh

Greetings, raghunadhs!

Please excuse my passiveness. I think you will find posts hre that deal with what you need, posted just recently.

I would add your title to search terms here, see what pops up. How's that for deal?

[TriciaL]

Try the TransferSpreadsheet method. One of the transfer type possibilities is "link". I'm new to this too so I haven't tried it myself, but I'm guessing this is the direction to go.

Hi every body!

I would like to develope an application. it should read data from existed excel sheet.besides this we can able to modify some of data in the excel sheets through our v.b application. it is urgent to me. can u say how to do it? and what controls are to be used.Actually i knew to v.b. kindly help me.
thank u:
regards:
raghunadhs

[kadghar]

Hi,

I'm not sure if this works for VB6, but i have used it many times in VBA

'First create an excel object
Set Obj1 = CreateObject("excel.application")
'Then call the workbook you want to open
Obj1.Workbooks.Open (xlFile)
'If you want to see what you are doing make it visible
Obj1.Visible = True
'And you can modify the first worksheet B1 cell this way:
Obj1.Worksheets(1).Cells(1,2).Value = "hello world"
'Dont forget to save the changes when you close it:
Obj1.ActiveWorkbook.Close savechanges:=True

Hope this help you.

If you have troubles getting the file route or you want to make it easier, you can always use a File Dialog:

With Application.FileDialog(msoFileDialogFilePicker)
.AllowMultiSelect = False
.Filters.Clear
.Filters.Add "Archivos de Excel (*.xls)", "*.xls"
.Filters.Add "Todos los Archivos (*.*)", "*.*"
.Show
If .SelectedItems.Count > 0 Then
xlFile = .SelectedItems.Item(1)
End If
End With