Access programming and Open Office Calc

[JamieJamie]

Hi

I have written a large application in Access 2003. In some parts of
the system I have coded it to output reports to Excel.

The problem is, I distribute this application to 50 pcs and not all of
them have Excel installed. I was hoping to re-write the application to
output to Open Office Calc. Is there VB script anywhere to give me
pointers on how to do this?

Please help. If Im right off track here, can you sudjest any other
ways of running an application which outputs to Excel but only when
Excel is present.

Thanks in advance

 

[Baz]

To be honest I've never encountered a computer that had Access installed but
not Excel. Howsoever, I'm sure Access can export data to xls files without
Excel actually being installed. Or CSV files. The question then is simply:
can Open Office Calc open xls files? Or CSV files?

Or, when you described outputting reports to Excel, did you literally mean
exporting Access Reports to Excel? (something I've always avoided because
the results always look so horrible in Excel)?

 

[Linq Adams via AccessMonster.com]

A lot of users out there have gone to Open Office instead of MS Office, and
as of ACC2000 you would get an error exporting to xls files unless Excel was
present.

And yes, Open Office can open xls files.

 

[JamieJamie]

A lot of users out there have gone to Open Office instead of MS Office, and
as of ACC2000 you would get an error exporting to xls files unless Excel was
present.

And yes, Open Office can open xls files.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200801/1

We have to export reports in Excel format as they are read in by other
computer systems externally.

Actually found the answer here

http://www.granite.ab.ca/access/latebinding.htm

Its all about the late binding. Allows me to produce Excel reports on
those pcs with Excel installed and not fall over on those pcs without
Excel

Although I would LOVE to write reports to open office calc. Any help
there would be great.

 

[Tony Toews [MVP]]

To be honest I've never encountered a computer that had Access installed but
not Excel. Howsoever, I'm sure Access can export data to xls files without
Excel actually being installed.

I suspect outputting to .xls files would require Excel.

Or CSV files.

That's much easier. Print and Write statements can do those within
VBA code.

Or, when you described outputting reports to Excel, did you literally mean
exporting Access Reports to Excel? (something I've always avoided because
the results always look so horrible in Excel)?

Agreed. I always use Recordsets.

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/

 

[Tony Toews [MVP]]

Actually found the answer here
http://www.granite.ab.ca/access/latebinding.htm
Its all about the late binding. Allows me to produce Excel reports on
those pcs with Excel installed and not fall over on those pcs without
Excel

I was just gong to post that URL.

Although I would LOVE to write reports to open office calc. Any help
there would be great.

I've been meaning to do some research there but haven't gotten around
to it. Too busy and not high enough on my priority list.

If you do find such please post your results here for others to use.

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/