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

Calc2QIF error in OOO 2.0

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API
View previous topic :: View next topic  
Author Message
dzrtrat67
General User
General User


Joined: 31 Dec 2005
Posts: 5

PostPosted: Mon Jan 30, 2006 7:37 am    Post subject: Calc2QIF error in OOO 2.0 Reply with quote

Trying to switch from Quicken 2005 Premier Home and Business to Calc/Base for simple invoicing. With 000 1.1.3, I'd get errors regarding dates when using Calc2QIF import function.
Trying it with 2.0, I get a different error...

The Basic window pops up with a small error window stating:
BASIC runtime error
object variable not set

The line in the Basic code that's highlighted is:
oPathSettings = oSettings.getByName( "PathSettings" )

Any suggestions?
Does Calc2Qif work with 2.0?

Thanks!
Rat
Back to top
View user's profile Send private message
pitonyak
Administrator
Administrator


Joined: 09 Mar 2004
Posts: 3655
Location: Columbus, Ohio, USA

PostPosted: Wed Feb 01, 2006 9:52 am    Post subject: Reply with quote

Can you find where oSettings is given its value?
_________________
--
Andrew Pitonyak
http://www.pitonyak.org/oo.php
Back to top
View user's profile Send private message Send e-mail Visit poster's website AIM Address
dzrtrat67
General User
General User


Joined: 31 Dec 2005
Posts: 5

PostPosted: Wed Feb 01, 2006 9:56 am    Post subject: Reply with quote

hehehe.....probably, if you can walk me thru it.

Rat
Back to top
View user's profile Send private message
pitonyak
Administrator
Administrator


Joined: 09 Mar 2004
Posts: 3655
Location: Columbus, Ohio, USA

PostPosted: Wed Feb 01, 2006 10:57 am    Post subject: Reply with quote

When the macro fails, do you end up in the Basic IDE? If you do, then this is easy.... If not, then it is more difficult...

You said that the Basic code is selected, so obviously you do...

Which library and module contains this code?
_________________
--
Andrew Pitonyak
http://www.pitonyak.org/oo.php
Back to top
View user's profile Send private message Send e-mail Visit poster's website AIM Address
dzrtrat67
General User
General User


Joined: 31 Dec 2005
Posts: 5

PostPosted: Wed Feb 01, 2006 11:12 am    Post subject: Reply with quote

hmmmm...ok.
Need more info... How do I find the module and library you're asking for?
I'm willing to learn a bit about how all this works, but I *will* need some serious handholding during the walkthru...
Thanks!
Back to top
View user's profile Send private message
dzrtrat67
General User
General User


Joined: 31 Dec 2005
Posts: 5

PostPosted: Thu Feb 02, 2006 3:53 pm    Post subject: Reply with quote

Also, in case it's not painfully obvious by now, I'm an end user, NOT a programmer. I hope this is the right forum for my questions.

Rat
Back to top
View user's profile Send private message
calc2qif.support
General User
General User


Joined: 05 Jan 2006
Posts: 6

PostPosted: Fri Feb 03, 2006 12:46 am    Post subject: Reply with quote

Hello,

I can confirm that Calc2qif works with OpenOffice.org 2.0

Two questions:
1] are you using the latest version of calc2qif (1.02)?
2] which OS are you using (windows XP, Linux ...)?

Didier - Calc2qif support

Note: the latest version of Cal2qif can be found here: http://xl2qif.chez-alice.fr/calc2qif_en.php
Back to top
View user's profile Send private message
dzrtrat67
General User
General User


Joined: 31 Dec 2005
Posts: 5

PostPosted: Fri Feb 03, 2006 7:53 am    Post subject: Reply with quote

ok... yes, I was using the latest version. I uninstalled/reinstalled it anyway and now it all seems to be working!
Of course, the sheet it generated from my quicken h&b .qif file is pretty disorganized. I doubt that's Calc2qif's doing though....more likely it's just the nature of .qifs

Thanks!
Back to top
View user's profile Send private message
calc2qif.support
General User
General User


Joined: 05 Jan 2006
Posts: 6

PostPosted: Mon Feb 06, 2006 12:17 am    Post subject: Reply with quote

What do you mean by "disorganized"?
Is there any specific organization of your data in Calc you're expecting after importing a QIF file?
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API 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