OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

How to Integrate Open Office with Quickbooks

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> Setup and Troubleshooting
View previous topic :: View next topic  
Author Message
grnidone
General User
General User


Joined: 01 Nov 2005
Posts: 6

PostPosted: Thu Feb 18, 2010 1:41 pm    Post subject: How to Integrate Open Office with Quickbooks Reply with quote

All,

Is it possible to integrate Open Office Suite with Quickbooks? I've seen the question asked several times before in these forums, but the question/ answers were rather old (2006) or so.

Has any progress been made on this front?

I read that it might be possible to fool Quickbooks by tweaking an .ini file and pointing to the executable of Open office instead of Microsoft Office products. Can anyone shed some light on this?
Back to top
View user's profile Send private message
grnidone
General User
General User


Joined: 01 Nov 2005
Posts: 6

PostPosted: Thu Feb 18, 2010 1:52 pm    Post subject: Reply with quote

Oh Holy WOW! I just found a potential answer here, although I have no idea if this will work. I will test this out to see if it does.

http://www.mail-archive.com/users@openoffice.org/msg72986.html

Quote:

Having used QuickBooks with OpenOffice, the easiest way to get them to work is
to change your file associations. Assuming you are using Windows (per your
e-mail), open Windows explorer and look for the various extensions that you
formerly used with MS Office. Find each one in turn, i.e. *.doc, *.xls, *.xlt,
*.csv, *.rtf, and any others that you often used and associate them to open
with OpenOffice.

In QuickBooks you can go into options and specify OpenOffice instead of MS
Office programs. If you share any of your documents you create in QuickBooks
with others, you may want to "Save As" MS Office documents, since MS Office
will not open OpenOffice documents.

If you (or QuickBooks) have any macros embedded in the spreadsheet templates
(Excel), or other templates, they will not work in OpenOffice. However, you can
reconstruct them with the Macro feature in OpenOffice, if it's worth the time
and effort for you.



Has anyone else tried this?
Back to top
View user's profile Send private message
grnidone
General User
General User


Joined: 01 Nov 2005
Posts: 6

PostPosted: Thu Feb 18, 2010 3:17 pm    Post subject: Reply with quote

OK...for the record, this DOES NOT work. I can't find anywhere in quickbooks to "choose" openoffice for office suite of choice.

I've checked every .ini file in quickbooks I can find, but can't find a place to edit that to openoffice programs either.

I'm very frustrated by this. I need to make a template to dump quickbooks data to a write file and cannot do it. Quickbooks stops mid export and says it cannot find Word. Well, DUH!

There *must* be a way around this...help?
Back to top
View user's profile Send private message
Moxieman99
Power User
Power User


Joined: 05 Jan 2005
Posts: 81

PostPosted: Sat Feb 20, 2010 8:39 am    Post subject: Reply with quote

Right click on a file that is normally opened with quickbooks and select the "open with" option from the pop up menu.

Select the desired appropriate application and click "okay." If you always want to use that application for that type of file, make sure that the check box below the list of possible applications is checked.

If the application you want is not in the list, then below the list you will see a "browse" button. Click on that and browse to the application you want to trigger when you use that file. Again, check (or not) the box that tells the computer to always use that file, depending on your preferences.
Back to top
View user's profile Send private message
notawawanuf
Newbie
Newbie


Joined: 02 Dec 2010
Posts: 1
Location: Sydney, Australia

PostPosted: Thu Dec 02, 2010 1:38 am    Post subject: Reply with quote

Hi
I know this thread is a bit long in the tooth but I've found a work-around for this:
To export a Quickbooks (say) report to OO:
1) Generate the report;
2) Select the "email" dropdown at the top of the report;
3) Select to send an XLS file;
4) Enter any email address;
5) When the email comes up, save the XLS attachment;
6) Discard the email;
7) Open the XLS file in OO - all formulas will be there.
I have both MS Office and OO installed but this dosen't open Excel, on my system. I would be interested to hear if this works for anyone who dosen't have MS Office installed.
All the best Leigh
Back to top
View user's profile Send private message
pattybenpatty
Newbie
Newbie


Joined: 01 Nov 2011
Posts: 3
Location: United States

PostPosted: Tue Nov 29, 2011 10:16 am    Post subject: Reply with quote

Sending as an Excel file won't work without Excel installed on the machine. I've been looking for an answer to this question for a year now.
Back to top
View user's profile Send private message
forrestcupp
Newbie
Newbie


Joined: 08 Jan 2012
Posts: 1

PostPosted: Sun Jan 08, 2012 2:55 pm    Post subject: Reply with quote

pattybenpatty wrote:
Sending as an Excel file won't work without Excel installed on the machine. I've been looking for an answer to this question for a year now.

But it will work if you have the free OpenOffice.org installed. There is no reason it wouldn't work to send an excel document through email and open the attachment with OpenOffice. That was a great idea.

I do wish Intuit wasn't so boneheaded that they make it impossible for it to work together, though.
Back to top
View user's profile Send private message
DeBorahB
Newbie
Newbie


Joined: 09 Jul 2012
Posts: 1

PostPosted: Mon Jul 09, 2012 10:21 am    Post subject: Any way to use Open Office for importing csv? Reply with quote

I've been trying to import my items list and so far QB does not see Excel. I usually use Open Office, but also have Office Starter installed on my new computer.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> Setup and Troubleshooting All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group