Hi Samuel,
I tried this with an excel spreadsheet that has many macros. I tested
one very complex one and it works fine. Check this out from OOo calc help:
In Tools - Options - Load/Save - VBA Properties
<vnd.sun.star.help://shared/text/shared/optionen/01130100.xhp?Language=en-US&System=WIN&UseDB=no>
you can specify the settings for the VBA macro codes in MS Office
documents. VBA macros are unable to run in OpenOffice.org; they must
first be converted and adapted. Often you only want to use
OpenOffice.org to change the visible content of a Word, Excel or
PowerPoint file and then save the file again in Microsoft Office format
without changing the macros they contain. You can set the behavior of
OpenOffice.org as desired: Either the VBA macros are saved in commented
form as a subroutine of OpenOffice.org and when the document is saved in
MS Office format are written back correctly again, or you can select the
Microsoft Office macros to be removed when loading. The last option is
an effective protection against viruses within the Micros
tc
Samuel Murray wrote:
JC Helary wrote on 13/02/2006 05:14 PM:
You want me to test a modified file ?
I've already tested a few files on my own computer. In none of the
cases (with different selections of tick boxes enabled) did the VB
code survive the MS Word 2000 -> OpenDocument -> MS Word 2000
roundtrip. Sometimes OOo warns me that the VB code will not be saved,
but on other occasions I get no such warning. Even so, I can't get
OOo to preserve the VB code.
Perhaps this function of OOo simply doesn't work.
Samuel
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
