
OLE: Excel worksheet without using Excel
Hi Brian
The easiest way is to use the Jet engine that ships with all versions of
vb3 upwards. You can use the spreasheet as a datasource and even bind
controls to it.
You could also use:
i) DAO - Faster but pro & enterprise only
ii) RDO using the Excel ODBC driver shipped gratis by MS
iii) ADO using the Excel ODBC driver and the ADO driver shipped with NT4
iv) API using the Excel ODBC driver
All of which are reportedly faster than the Jet engine.
Take your pick!
Alban
Quote:
> Does Anyone know if this is possible?
> I wish to write a simple VB program that uses an Excel spreadsheet
> but, I want to copy this program onto workstations that do not have
> Excel. Is it possible for these workstations to update the
> spreadsheet within the program without having Excel on their machines?
> Thanks in Advance
> Marc Gordon