Hello, Does anyone out there know how to open an Excel 5.0 workbook. I need to navigate through the rows and columns and reference specific cells. Any ideas?
Thanks in advance, Matt
Mon, 16 Mar 1998 03:00:00 GMT
Jim Rind #2 / 3
Opening a Excel 5.0 Workbook with VB Code
1. Search VB help for OLE. 2. Get out the ODK and search help for OLE EXCEL
There are a ton of examples in the ODK .... Jim-
Quote:
>Hello, >Does anyone out there know how to open an Excel 5.0 workbook. I need >to navigate through the rows and columns and reference specific cells. >Any ideas?
>Thanks in advance, >Matt
Tue, 17 Mar 1998 03:00:00 GMT
Doug Graha #3 / 3
Opening a Excel 5.0 Workbook with VB Code
You can do this with ODBC if you have the appropriate drivers. If you don't have the drivers you can get them from MS easy enough.
It's also my unstanding that you can use the data control in VB 4 to attach Excel spreadsheet ranges. You can not delete data but you can browse it and enter it. I don't have my 4.0 yet so I have not been able to check this out first hand. Maybe someone else can comment on this.
Opening a Excel 5.0 Workbook with VB Code