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. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org 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
