What do I need for LibreOffice to run my Excel Macros?

[KenW1]

Hi,
My owner would like to implement LibreOffice in our small Tool and Die Company instead of using Excel.
I have a Excel macro that determines our On Time Delivery. In this macro it copies data from a couple of excel files into one file to crunch the data. When I open up the file in LibreOffice the macro does not work. When I try to understand the macros in LibreOffice, the language is completely different than the Macro language in excel.
My Options are set to LibreOffice-Advanced “Use a Java runtim enviroment” Vendor Oracle Corpation.
Is this correct for running my Excel Macros?

[KenW1]

It did not help. I placed Option VBASupport 1 and Option Compatible in the front of the Macro. (Option VBA Support 1 was already there.) The maro runs up to " Windows(“Data1.xls”).Activate" and an error message comes up "BASIC runtime error. ‘1’ Type:com.sun.star.container. NosuchElementException Message.

[mariosv]

A comment here:

Import MS-Word Macros

Hi, I’m working on switching from MS-Word to LibreOffice. I have lots of Macros I created in Word and started reading into importing them into LibreOffice. As it seems they need kind of “translation” which is doen automatically. When I open the normal.dot in LO then I get all the macros and they do work when I run them (some adjustments needed. But when I copy them into the My Macros/Synadartd/Module1 then the same macros do not work any more … guess this is because of the translation needed. …

[KenW1]

I’m learning how to use this web site. I placed my comment in my Question. I realized that I should have placed it here. I also created a new question asking why “Windows(“Data1.xls”).Activate does not work. For your answer, it did not help. I placed Option VBASupport 1 and Option Compatible in the front of the Macro. (Option VBA Support 1 was already there.) The maro runs up to " Windows(“Data1.xls”).Activate” and an error message comes up "BASIC runtime error. ‘1’ Type:com.sun.star.container. NosuchElementException Message.

[KenW1]

It did not help. I placed Option VBASupport 1 and Option Compatible in the front of the Macro. (Option VBA Support 1 was already there.) The maro runs up to " Windows(“Data1.xls”).Activate" and an error message comes up "BASIC runtime error. ‘1’ Type:com.sun.star.container. NosuchElementException Message.