Macros not working correct

Discuss the spreadsheet application

Macros not working correct

Postby peter.muss » Sat May 17, 2008 11:08 am

Hello all!

Im new to this community and just started with OOo, 2.4.0, german version for Windows.
First, pls pardon my bad english.

Im a little bit in trouble with one Excel spreadsheet from one customer. After opening this sheet into OOo calc, the macro(s) are not working correct. Opening the sheet with Excel 2003 will bring up results to the "Material Nr.:" cell, when you entered a "Typenschlüssel" like 4we10.... to the cell.

Using calc, this function/macro does not work. Any hints in this case for me?

I uploaded both, the xls and ods file to my webspace. To minimize up- and download-time, the files are zipped and could be downloaded here:
Posts: 3
Joined: Sun May 11, 2008 1:31 pm

Re: Macros not working correct

Postby kingfisher » Sat May 17, 2008 11:36 am

Excel macros do not (usually) work in Calc because Calc does not recognise Visual Basic, the language used for Excel macros. The macros need to be rewritten in a language, such as StarBasic, recognised by Calc.

There is some support for Visual Basic, I understand, in the Novell version of Open Office.
Apache OpenOffice 4.1.6 on PCLinuxOS
User avatar
Posts: 2120
Joined: Tue Nov 20, 2007 10:53 am

Return to Calc

Who is online

Users browsing this forum: No registered users and 16 guests