Excel Library Access 2003

[JamieJamie]

Hi

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.

 

[db ´¯`·.. >]

saw your post from last week
but it seemed that it was a posting
pertaining to the need for your
company to acquire more microsoft
software but instead is choosing
to pinch you and that ol' shiny
penny the boss uses to buy caviar.

it has been a while for me,
but i think that the database
in access simply needs be
redesigned to produce all of
its results without the need
of sending the output to an
excel program (which is possible)

"or" simply get everyone
a copy of excel.

or get those pc's with both
softwares to produce the
excel output to a
centralized folder then
get everyone who does
not have both programs an
excel viewer to access and
view those outputs.

i suppose you may suspect
but if you try opening the
database and try to override
it with excel system files, it
will likely crash the entire
system.

you might try reposting your
question directly on an access
newsgroup:

http://www.microsoft.com/office/community/en-us/FlyoutOverview.mspx

something that
might be of interest:

http://blogs.msdn.com/excel/archive/2005/11/08/490502.aspx

--

<)))º>·´¯`·.¸. , . .·´¯`·.. ><)))º>`·.¸¸.·´¯`·.¸.·´¯`·...¸><)))º>

..

 

[JamieJamie]

saw your post from last week
but it seemed that it was a posting
pertaining to the need for your
company to acquire more microsoft
software but instead is choosing
to pinch you and that ol' shiny
penny the boss uses to buy caviar.

it has been a while for me,
but i think that the database
in access simply needs be
redesigned to produce all of
its results without the need
of sending the output to an
excel program (which is possible)

"or" simply get everyone
a copy of excel.

or get those pc's with both
softwares to produce the
excel output to a
centralized folder then
get everyone who does
not have both programs an
excel viewer to access and
view those outputs.

i suppose you may suspect
but if you try opening the
database and try to override
it with excel system files, it
will likely crash the entire
system.

you might try reposting your
question directly on an access
newsgroup:

http://www.microsoft.com/office/community/en-us/FlyoutOverview.mspx

something that
might be of interest:

http://blogs.msdn.com/excel/archive/2005/11/08/490502.aspx

--



.










- Show quoted text -

Hi

Thanks for your response. I need all the help I can get.

To try and explain myself better. The company i wrote the system for
have 50 plus pcs. 10 of those are used for printing reports, the rest
just kinda data input, invoice printing etc.

The bosses have brought all 50 Access licenses but only Excel licenses
for 10 PCs. The system front end is distributed to all 50 PCs. Because
the system (written in Access) uses excel libraries and related vb
code, the whole thing dosent work on PCs without Excel. (thats 40
pcs!). And yes, your right, in an ideal world the bosses should just
buy an additional 40 Excel licenses but its cars that are their
passion not caviar!

Removing the Excel library from Access is what causes the problems. So
Im wondering what the hell I should (and also why Im using up company
time and resources looking at this rather than buying licenses!).

 

[JamieJamie]

Hi

Thanks for your response. I need all the help I can get.

To try and explain myself better. The company i wrote the system for
have 50 plus pcs. 10 of those are used for printing reports, the rest
just kinda data input, invoice printing etc.

The bosses have brought all 50 Access licenses but only Excel licenses
for 10 PCs. The system front end is distributed to all 50 PCs. Because
the system (written in Access) uses excel libraries and related vb
code, the whole thing dosent work on PCs without Excel. (thats 40
pcs!). And yes, your right, in an ideal world the bosses should just
buy an additional 40 Excel licenses but its cars that are their
passion not caviar!

Removing the Excel library from Access is what causes the problems. So
Im wondering what the hell I should (and also why Im using up company
time and resources looking at this rather than buying licenses!).- Hide quoted text -

- Show quoted text -

Also the reports need to be outputted to Excel cos they are picked up
as files by other companies and read in

 

[db ´¯`·.. >]

as a programmer i do sympathize
with your predicament and there
are a number of options available.
therefore the situation your company
is in are not dire.

unfortunately, i can see but
a few options "you" have:

you will either have to roll up
your sleeves and rewrite your
database to exclude any external
modules, like excel, word, outlook,
etc.

or write a new front end for
those pc's who do not have
external modules installed.

the front end scenario is likely
the best solution, including
for those that have excel installed.

some people forget but excel
can be linked to msaccess datafiles
and excel can also be programmed to
generate specialized reports.

there are other options i would
share, but they wouldn't benefit "you"
or provide "you with job security".

the bottom line:

american employees are expendable,
imported fine cars are not... }: (

--

<)))º>·´¯`·.¸. , . .·´¯`·.. ><)))º>`·.¸¸.·´¯`·.¸.·´¯`·...¸><)))º>

..

Hi

Thanks for your response. I need all the help I can get.

To try and explain myself better. The company i wrote the system for
have 50 plus pcs. 10 of those are used for printing reports, the rest
just kinda data input, invoice printing etc.

The bosses have brought all 50 Access licenses but only Excel licenses
for 10 PCs. The system front end is distributed to all 50 PCs. Because
the system (written in Access) uses excel libraries and related vb
code, the whole thing dosent work on PCs without Excel. (thats 40
pcs!). And yes, your right, in an ideal world the bosses should just
buy an additional 40 Excel licenses but its cars that are their
passion not caviar!

Removing the Excel library from Access is what causes the problems. So
Im wondering what the hell I should (and also why Im using up company
time and resources looking at this rather than buying licenses!).- Hide quoted
text -

- Show quoted text -

Also the reports need to be outputted to Excel cos they are picked up
as files by other companies and read in