Creating Excel sheet by using XPAPIs dll without office installed at server

[anilkumarup]

Code--
objExcel = New Excel.Application
Error/Exception-- I have included all the apis
microsoft.office.interop.excel etc in bin
but it is not able to make object of excel class.

Please suggest, is it possible to create an excel sheet using above
COM objects, without MS Office installed.
Thanks
Anil

[Peter Sutton]

You need to set a reference to MS Excel in Access by opening
a code module and selecting Tools | References first.

What is the error message? Something like variable not defined?

Code should be something like
dim objExcle as object
Set objExcel = New Excel.Application
On Thu, 16 Aug 2007 03:53:25 -0700, an*********@gmail.com wrote:

>Code--
objExcel = New Excel.Application
Error/Exception-- I have included all the apis
microsoft.office.interop.excel etc in bin
but it is not able to make object of excel class.

Please suggest, is it possible to create an excel sheet using above
COM objects, without MS Office installed.
Thanks
Anil

[RoyVidar]

an*********@gmail.com wrote:

Code--
objExcel = New Excel.Application
Error/Exception-- I have included all the apis
microsoft.office.interop.excel etc in bin
but it is not able to make object of excel class.

Please suggest, is it possible to create an excel sheet using above
COM objects, without MS Office installed.
Thanks
Anil

I don't *think* it is possible to automate Excel without Excel being
installed on the computer, but I think you're more likely to get
a reply to your question in a NG related to the technology you're
using. It seems you're using some .Net stuff. This is an NG dedicatet
to Microsof Access.

--
Roy-Vidar