Ask Your Question
0

vba doesn't work after saving file on libre [closed]

asked 2012-03-11 13:31:52 +0200

anonymous user

Anonymous

updated 2015-09-06 14:09:27 +0200

Alex Kemp gravatar image

I use excel files with vba, under LibreOffice. After installing version 3.5 of LibreOffice, vba works at the beginning, but when I save file(in MSoffice 2003 format) and close it and after that open it again, the vba macros do not work.

If I use OOo and version 3.3 of LibreOffice it works . What is the difference ?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-20 20:40:37.824026

Comments

Hi @pawnbroker1997, Have you been able to find an answer to your question? I believe that @moggi may be correct regarding LO's ability to output VBA code into an Excel file, however that functionality may have been implemented in the last few months. Please let us know how things are going for you!

qubit gravatar imagequbit ( 2013-01-22 04:17:17 +0200 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2012-05-04 19:25:34 +0200

m.a.riosv gravatar image

Take a look in: Menu/Tools/Options/Load-Save/VBA properties

edit flag offensive delete link more
0

answered 2012-05-04 12:07:20 +0200

gnowak gravatar image

As far as I understand the concept, the VBA is converted to Star Basic when it is imported to Libre Office. Then when you save it in Excel format it can't convert it back to VBA.

I am not sure about this, but I think it is the reason for your problem.

BR. GrN.dk

edit flag offensive delete link more

Comments

1

This is wrong. We can't save vba macros correctly back. We just copy the vba stream back into the file.

moggi gravatar imagemoggi ( 2012-05-06 01:32:55 +0200 )edit

Also we don't convert VBA macros to StarBasic. They are still Vba macros, we just don't have a feature for saving them back into the file.

moggi gravatar imagemoggi ( 2012-05-06 01:33:47 +0200 )edit

Question Tools

Stats

Asked: 2012-03-11 13:31:52 +0200

Seen: 1,295 times

Last updated: Jan 22 '13