Calc2QIF install tips?
allanhasmail at gmail.com
Sun May 3 23:48:38 EDT 2015
Ah, it IS a security problem. In Calc: Tools->Options->Security->Macro
Security: Adding the path to the calc2qif allows it to run.... but:
BASIC runtime error.
Property or method not found: $(ARG1).:
stops at oDialog.Execute() in Sub Install.
I wonder how to edit this to work around whatever's wrong here...
Dim Style as Integer, Response as Integer
' Installation is not working with OpenOffice 1.0.x
If Left (OOoVersion(),3) = "1.0" Then
Style = MSGBOX_OK + MSGBOX_ICON_STOP 'OKonly + STOP
MsgBox (sUnsupportedVersion, Style, sInstallTitle)
Style = MSGBOX_YES_NO + MSGBOX_ICON_QUESTION + MSGBOX_DEFAULT_SECOND
'YesNo + Question + DefaultButton2
Response = MsgBox(sInstall, Style, sInstallTitle)
If Response = 7 Then 'No
Style = MSGBOX_OK + MSGBOX_ICON_EXCLAMATION 'OKonly + Exclamation
MsgBox (sInstallCancelled, Style, sInstallTitle)
AddBasicLibrary ( "Calc2qif", "Calc2qif" )
oDialog = LoadDialog("Standard", "DialogMenuChoice")
' FOLLOWING LINE STOPS WITH ERROR
Style = MSGBOX_OK + MSGBOX_ICON_TIP 'OKonly + Information
MsgBox (sInstallFinished, Style, sInstallTitle)
'oDocument = StarDesktop.getCurrentComponent
'If HasUnoInterfaces(oDocument, "com.sun.star.util.XCloseable") Then
On 05/03/2015 06:22 PM, David Carlson wrote:
> On 5/3/2015 5:40 PM, Allan wrote:
>> That looks to be version 0.91, a couple years older than what I have:
>> V1.03: (February 06, 2006)
>> Looking over this list archives, I found:
>> On Wed, Apr 23, 2014 at 4:52 AM, <anders.vinjar at bek.no> wrote:
>>> I just installed this one:
>>> to libreoffice 184.108.40.206, which works.
>>> After getting rid of all remainings from previous attempts of earlier
>>> versions of calc2qif (i tried first v. 0.97 or something) - the install
>>> went well, and calc exports to qif as expected.
>>> Small note: after installing (opening calc2qif.sxc in calc, choosing
>>> install, and a place (i chose as 'add-on')) the 'install'-dialog didnt
>>> go away or respond with anything. Only after closing the small window,
>>> calc respondend that the installation was successful, and a message to
>>> restart and start using it.
>> I guess I could backtrack to this older version of Libreoffice, IDK.
>> Doesn't make sense.
>> On 05/03/2015 04:19 PM, nvsoar wrote:
>>> On 5/3/2015 7:53 AM, Allan wrote:
>>>> Any tips for getting the Calc2QIF macro from
>>>> http://xl2qif.chez-alice.fr/xl2qif_en.php working in LibreOffice
>>>> I open the calc2qif.sxc file, click the Install (En) and nothing
>>>> happens. I tried installing it from Tools->extension manager which
>>>> didn't work and it seemed to corrupt something, because then I got
>>>> errors removing it and couldn't remove it.
>>> Try http://sourceforge.net/projects/ooomacros/files/Calc2qif/
>>> no guarantees - found on http://en.libreofficeforum.org/node/5040
>>> from 2013
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> Your problem may relate to the macro versions supported by OO vs LO. I
> think neither suite directly supports the old Microsoft VBA. Not sure,
> I don't have any version working here.
> David C
> gnucash-user mailing list
> gnucash-user at gnucash.org
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
More information about the gnucash-user