Hi,
There are some accounting programs like Quickbooks and Peachtree that
export to Excel. AccountEdge exports to a spreadsheet. I am searching
for a way to fool the crippled programs into thinking they are exporting
to Excel when it is actually OpenOffice or LibreOffice that is installed -
or anything else for that matter (Numeric).
Has any one looked into this? What do you think?
Bob
Try installing Excel Viewer?
On 3/1/2013 11:50 AM, Bob Crandell wrote:[color=blue]
Hi,
There are some accounting programs like Quickbooks and Peachtree that
export to Excel. AccountEdge exports to a spreadsheet. I am searching
for a way to fool the crippled programs into thinking they are exporting
to Excel when it is actually OpenOffice or LibreOffice that is installed -
or anything else for that matter (Numeric).Has any one looked into this? What do you think?
Bob
[/color]
–
Craig Wilson - MCNE, MCSE, CCNA
Novell Knowledge Partner
Novell does not officially monitor these forums.
Suggestions/Opinions/Statements made by me are solely my own.
These thoughts may not be shared by either Novell or any rational human.
Bob Crandell wrote:
[color=blue]
I am searching
for a way to fool the crippled programs into thinking they are
exporting to Excel when it is actually OpenOffice or LibreOffice[/color]
OpenOffice and LibreOffice can open Excel files. Do those accounting
programs offer the option to simply create a spreadsheet file or do
they try to launch Excel directly?
I remember several years ago some programs trying to launch Microsoft
Word directly. I never did find a way to get them to use OpenOffice. 
–
Kevin Boyle - Knowledge Partner
If you find this post helpful and are logged into the web interface,
show your appreciation and click on the star below…
Don’t they export to CSV? If they export to Excel, they should export
to CSV, and CSV can be opened by any spreadsheet program. : )
–
Susan
Novell Community Chat Moderator
http://forums.novell.com/faq.php?faq=novfor#faq_rules
http://www.ncci.org NCCIrregulars Web Site
https://www.facebook.com/groups/NCCIrregulars
Please read the following before posting in here:
http://preview.tinyurl.com/27zopdy
On 3/2/2013 12:56 PM, KBOYLE wrote:[color=blue]
Bob Crandell wrote:
[color=green]I am searching
for a way to fool the crippled programs into thinking they are
exporting to Excel when it is actually OpenOffice or LibreOffice[/color][/color]
Quickbooks exports either to csv or iif. I don’t think it can even do an
export in xls format.
[color=blue]
OpenOffice and LibreOffice can open Excel files. Do those accounting
programs offer the option to simply create a spreadsheet file or do
they try to launch Excel directly?I remember several years ago some programs trying to launch Microsoft
Word directly. I never did find a way to get them to use OpenOffice.
[/color]
On Sat, 02 Mar 2013 17:56:41 +0000, KBOYLE wrote:
[color=blue]
Bob Crandell wrote:
[color=green]I am searching
for a way to fool the crippled programs into thinking they are
exporting to Excel when it is actually OpenOffice or LibreOffice[/color]OpenOffice and LibreOffice can open Excel files. Do those accounting
programs offer the option to simply create a spreadsheet file or do they
try to launch Excel directly?I remember several years ago some programs trying to launch Microsoft
Word directly. I never did find a way to get them to use OpenOffice. :-([/color]
That is what I’m trying to do. Though those programs will export other
formats, they make the end user jump through more hoops which takes all
the fun out of it. A long time ago a user let me experiment with their
computer. I forget which accounting system they were using but without
MS Office installed there was no export option. With OpenOffice
installed there was still no export option. Installed MS Office and then
there was an export option. It was a sad couple of days. Without MS
Office installed she could fumble around and find a way to export some
stuff in a couple of formats but the ability to bring up a report and
have the option to print or export wasn’t available until MS Office was
installed.
Oh well.
Bob Crandell wrote:
[color=blue]
Without MS
Office installed she could fumble around and find a way to export
some stuff in a couple of formats but the ability to bring up a
report and have the option to print or export wasn’t available until
MS Office was installed.[/color]
Maybe the answer is to find out what the program needs to see to offer
the export function and then add a couple of entries to the registry.
–
Kevin Boyle - Knowledge Partner
If you find this post helpful and are logged into the web interface,
show your appreciation and click on the star below…