Access 2003 and Excel 2003

[JamieJamie]

Is there anyway of installing the Excel Object library in Access 2003
without actually installing Excel. Or is there anyway of deleteing
Excel and leaving the library in place.


The reason for my question is I have developed an Access application
which runs on 50 plus pcs. The application included Excel reporting.
Unfortunately we have 50 Access licenses and only 10 Excel licenses.
Those pcs without an Excel license run the same application but wont
be reporting in Excel. But without the library, which only seems to
be
in place with Excel installed, the application will not compile.


ANY help will be very gratefully received.


Thank you in advance.

 

[boblarson]

Unless someone else knows something I don't, the object library for Excel is
not redistributable without having a license for the Developer's edition of
Access 2003. So, essentially the answer is No.

--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________

 

[Tony Toews [MVP]]

Is there anyway of installing the Excel Object library in Access 2003
without actually installing Excel. Or is there anyway of deleteing
Excel and leaving the library in place.

The reason for my question is I have developed an Access application
which runs on 50 plus pcs. The application included Excel reporting.
Unfortunately we have 50 Access licenses and only 10 Excel licenses.
Those pcs without an Excel license run the same application but wont
be reporting in Excel. But without the library, which only seems to
be in place with Excel installed, the application will not compile.

Late binding means you can safely remove the reference and only have
an error when the app executes lines of code in question. Rather than
erroring out while starting up the app and not allowing the users in
the app at all. Or when hitting a mid, left or trim function call.

This also is very useful when you don't know version of the external
application will reside on the target system. Or if your organization
is in the middle of moving from one version to another.

For more information including additional text and some detailed links
see the "Late Binding in Microsoft Access" page at
http://www.granite.ab.ca/access/latebinding.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/