By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,285 Members | 1,636 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,285 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Aug 16 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Aug 18 '07 #2

P: n/a
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
Aug 18 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.