I need to open and read an Excel 97 file. Previously I have managed to create an Excel workbook and write to it using the following code:
Set objXLapp = CreateObject("Excel.Application")
Set objXLbook = objXLapp.Workbooks.Add
Set objXLsheet = objXLapp.Worksheets(1)

I thought that I could use a similar method for opening an existing Excel file. But I have had no sucess in finding the right code.

Has anyone got any ideas or pointers?

All help appreciated