[Solved] Excel macros won't work in Calc

[mrjcbeau]

None of the macros in my excel file work in OpenOffice. I can't even find
any reference to macros in OpenOffice. Is there something additional that I
need in order to use macros?

I am currently running windows 10 on my desk top

Edit: Changed subject, was No Macros  Make your post understandable by others  -- MrProgrammer, forum moderator

[FJCC]

There are macros in OpenOffice. You can search the Calc Help to get some information. OpenOffice has a very limited ability to run Excel macros. You will very likely have to rewrite them. That is because the Application Programming Interface is completely different and translating the code automatically is like asking a computer to translate between human languages perfectly. If you are interested in learning OpenOffice macros, people here can help and there is lots of information at https://pitonyak.org/oo.php. It is a big task.

[mrjcbeau]

Well thanks for the info, that definitely answers my question. Not the answer I was looking for. Being as I have hundreds of macros rewriting them is not a viable option.
It looks like I'm going to have to break down and pay for a copy of MS office.

Thanks for the quick and complete response.