Calc2QIF error in OOO 2.0

dzrtrat67 · General User Joined: 31 Dec 2005 Posts: 5

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

pitonyak · Posted: Wed Feb 01, 2006 9:52 am Post subject:

Can you find where oSettings is given its value?
_________________
--
Andrew Pitonyak
http://www.pitonyak.org/oo.php

dzrtrat67 · General User Joined: 31 Dec 2005 Posts: 5

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

Rat

pitonyak · Posted: Wed Feb 01, 2006 10:57 am Post subject:

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

dzrtrat67 · General User Joined: 31 Dec 2005 Posts: 5

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!

dzrtrat67 · General User Joined: 31 Dec 2005 Posts: 5

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

calc2qif.support · General User Joined: 05 Jan 2006 Posts: 6

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

dzrtrat67 · General User Joined: 31 Dec 2005 Posts: 5

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!

calc2qif.support · General User Joined: 05 Jan 2006 Posts: 6

What do you mean by "disorganized"?
Is there any specific organization of your data in Calc you're expecting after importing a QIF file?