Hi:
I had the same error (13) but I continue trying and it runs all well.
It was in OpenOffice 3.2 ... I think that in LibreOffice should run
well.
Regards,
Jorge Rodríguez
_______________
El vie, 13-01-2012 a las 05:54 -0800, Tom escribió:
> Hi :)
> I don't use macros at all so i don't know how to access the code. Jay's
> idea seemed smart. In LibreOffice go up to the menus at the top and click
> on
>
> Tools - Options - "+ Load/Save" - "VBA Properties"
>
> and then tick all the options in there and then re-load the invoice. You
> might also need to let LibreOffice know what the data-source is? When i
> tried to open the file it gave me a warning about my security settings
> blocking macros and i think that might be a default setting. Try
>
> Tools - Options - "LibreOffice" - Security - "Macro Security" - "Security
> Level"
>
> Mine was set to the 2nd highest so i set it lower. This time it enabled
> macros but gave me the error mesage
> "BASIC run-time error "13"
> Data type mis-match"
> which i guess is because i don't have the data-source/contacts-sheet.
>
>
> I did find it interesting that LibreOffice allows macros to be written in a
> choice of 4 languages; LibreOffice (Basic), Python, BeanShell (!?!) and
> JavaScript (worth avoiding?). The subject-line is a lot clearer now. I
> think the VBA Basic of MS Office is slightly different from the Basic used
> by LibreOffice.
>
> Capital letters are usually used to shout or be abusive towards someone. So
> a lot of people might view this thread as being hostile. I think you are
> using capital letters to be clearer because you are not a
> native-English-speaker. Most people wont know about that so they might be
> taking offence and hiding away.
>
> Regards from
> Tom :)
>
> --
> View this message in context:
> http://nabble.documentfoundation.org/PROBLEM-WITH-VBA-MACRO-IN-CALC-FROM-EXCEL-tp3656548p3656705.html
> Sent from the Users mailing list archive at Nabble.com.
>
--
Atentamente,
Jorge Rodríguez
--
For unsubscribe instructions e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
