View Single Post
  #1 (permalink)  
Old June 6th, 2003, 07:26 AM
walgie walgie is offline
Registered User
Join Date: Jun 2003
Location: Jacksonville, FL, USA.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Excel but no Office

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
Reply With Quote