Well y'all...

When I last wrote, I was looking for the command sequence
that could be passed from the 3000 to a Reflection session
to initiate a VBA module.  Thanks to those responding and
since that time we have been able to do some fun things
with it.

At present, we have a 3000-resident command file "ToExcel"
that enables us to pass output directly from Quiz, through
Reflection into a new Excel spreadsheet.  What continues
to surprise me about this technique is that it is unexpectedly
fast.  Understand that this does _NOT_ involved any ODBC or
socket-based middleware.  Although we have not tried it
as of yet, this should work even with your favorite
programming language.  Also, it should work across serial
connections as well as network connections.

The technique involves ECHOing a full VBA module, 90 lines,
from inside a Quiz session.  The Quiz program simply
transfers the data as a single column data stream which
is captured by the VBA module.  The VBA module handles
creating the Excel object and loading the data.  Right
now, thats pretty much it.  Some transfer times I've
seen are around 40-70 cells per second across our network.
(YMMV)

I don't have a web page to put this on but if you are
interested just e-mail me and I'll forward what we've
done plus maybe a better explaination.

Chip Dorman
Greenfield Industries