XLS to ODS Macro Import

[CLB]

What must I do to let a file with macro's written in *.xls to work in *.ods

It gives the output as per attachment.

tx

[Hagar Delest]

Rewrite them.
Or see those threads:
- [Solved] OO 2.4 Calc Compatibility problem with MS Excel
- Can't run a VBA macro from MS Excel file

Thanks to add '[Solved]' at beginning of your first post title (edit button) if your issue has been fixed.

NB: moved your thread in the Calc forum, it's not a formula issue.

[Villeroy]

In most cases you have to rewrite everything. The Basic language is almost the same while talking to a completely different thing. There is a "VBA compatibility mode" in StarOffice and some flavours of OOo, but from what I've seen in the forums this does a bad job so you can not say for shure if the code really does the same thing it used to do with the other application.
The most recent example for "VBA compatibility" wasting time: http://www.oooforum.org/forum/viewtopic.phtml?t=71839

[kingfisher]

You will almost certainly have to rewrite the macros in a language recognised by OO. Choices are StarBasic (probably the easiest), Python and Java.