Is it possible to write data to an Excel file from a VB app, if Excel
is not present on the end users machine?

I have used DDE to do this successfuly using;

Set xlApp = CreateObject("Excel.Application")
Set xlWb = xlApp.Workbooks.Open(filename:="X:\somefile.xls")

but I need to be able to write data to excel files with the installed
VB app, on PC's that do not have Excel installed on them.

Is this possible?

Thanks;
Don Wise

You can use ODBC, although the ODBC driver for excel has some limitations

--
Marco A. Garcia
Canaima Software
1632 Dale Street
San Diego, CA 92102
Tel/Fax: (619) 233-6831
http://www.canaimasoft.com
Developers of f90SQL, the database connectivity library for fortran, and
f90VB the library for seamless Fortran-VB integration

If you can't get other people's suggestions to work, a safe fall-back
solution is to write out a CSV file.  These are dead-simple text-based files
and Excel reads them with no problems.

Ofcourse you can't store formatting info (colours, fonts, etc), or include
formulas, but if you just want a grid of data, they're perfect.
--

| Digital Routes, Inverness, Scotland, www.digitalroutes.co.uk