I'm fairly new to VB
, so please bear with me on this.
I have written a VB6 batch job that reads a Sql Server table and creates an Excel spreadsheet.
It works great on my desktop, but as soon as I move it down to a W2k server, it abends with a "Activex component can't create object" message.
The obvious is the W2K server does not have Office installed.
This leads to my question:
Is it possible to create an Excel spreadsheet from VB
when MS Office has not been installed?
William R. Algie