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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

anilkumarup@gmail.com - 16 Aug 2007 11:53 GMT

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

Reply to this Message

Peter Sutton - 18 Aug 2007 07:45 GMT

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

>Code--
>
[quoted text clipped - 9 lines]
>Thanks
>Anil

Reply to this Message

RoyVidar - 18 Aug 2007 08:47 GMT

> Code--
>
[quoted text clipped - 9 lines]
> 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.

Signature

Roy-Vidar

Reply to this Message