How do I display an Excel sheet?

[Datacide]

Ok, I've scoured the forums and can't find an (easy ) answer to this. Someones got to walk me through now.

I want my users to select an excel file and then have it load the worksheet (display it) into a table. I don't care if the table is directly editable or if it launches Excel to edit it, but I need to be able reference the cells in the table.

Thanks.

[DKenny]

I want my users to select an excel file and then have it load the worksheet (display it) into a table.

Into what type of a table? Can you give some more info?

[RobDog888]

Do you mean like a VB6 FlexGrid thats related to your selected Excel file?

[Datacide]

Ya either a FlexGrid thingy or an Excel OLE, or whatever would be best.

[si_the_geek]

well here's one way... add a reference to "Microsoft Excel X.X Object library", and use code like this:

'**  Declarations section
Dim oXLApp as Excel.Application         'Declare the object variables
Dim oXLBook as Excel.Workbook
Dim oXLSheet as Excel.Worksheet
 
'** To open the file:
  Set oXLApp = New Excel.Application    'Create a new instance of Excel
  Set oXLBook = oXLApp.Workbooks.Open("C:\folder\file.xls")    'Open your workbook
  Set oXLSheet = oXLBook.Worksheets(1)  'Work with the first worksheet
  oXLApp.Visible = True
 
'** To work with the data:
  With oXLSheet           'Find the row to write to
    MsgBox .Cells(2, 1)   '(A2)
    .Cells(1, 2) = Text2.Text   '(B1)
  End With
 
'** To save the file:
  Set oXLSheet = Nothing             'disconnect from the Worksheet
  oXLBook.Close SaveChanges:= True   'Save (and disconnect from) the Workbook 
  Set oXLBook = Nothing
  oXLApp.Quit                        'Close (and disconnect from) Excel 
  Set oXLApp = Nothing

[Datacide]

But will that display the spread sheet? That's what I reall need.

[RobDog888]

If you need to reference the cells in the table are you refering to the VB6 Grid side or Excels Cells? If Excel then your better off using the Excel Object Model in VB6. If you use the OLDE Control then you cant reference the Cells in VB6 without re-opening the file using the EOM. so not much point. See, better just using EOM to load your Grid.

[Datacide]

Ok, if I place the Microsoft Excel Workheet control thingy on my form, who do I change which file it displays and how would I get the data from the cells?