calc2qif broken after upgrading to Windows 10

[David T.]

I don’t use calc2qif or OpenOffice OR Windows, but the error suggests that the data supplied is not good. Have you tried using the macro with a known-good data file? If it works with a known-good file, then that reinforces my surmise, and closer examination of the problem file is in order; if it does not, then someone else will have to weigh in on what else might be wrong…

David

> On Aug 5, 2016, at 7:30 AM, Kash <kash at warmplanetbikes.com> wrote:
> 
> Thanks in advance for any help you can offer.
> 
> I've used calc2qif for many years to import transactions into Gnucash. It's worked flawlessly. I cannot be certain that the upgrade to Windows 10 is causing the problem, but it's the only thing that's changed in my process and system.
> 
> When I run calc2qif an OpenOffice Basic code window opens with this error message:
> OpenOffice 4.1.1
> Inadmissible value or data type.
> Data type mismatch.
> 
> and this line of code highlighted:
> iYear = Year(DateValue(sDate))
> 
> The date format that I use is:
> MM/DD/YYYY
> and I have tried several variations on date format, all with the same result.
> 
> I have also tried to import an archived .csv file that worked in the past and get the same error.
> 
> Any ideas?
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.