Ask Your Question
0

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

asked 2013-03-01 20:25:03 +0100

Ken W gravatar image

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? image description

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-25 05:49:42.795755

Comments

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.

Ken W gravatar imageKen W ( 2013-03-04 15:07:53 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2013-03-02 01:55:42 +0100

m.a.riosv gravatar image
edit flag offensive delete link more

Comments

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.

Ken W gravatar imageKen W ( 2013-03-08 17:00:16 +0100 )edit

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.

Ken W gravatar imageKen W ( 2013-03-08 17:00:22 +0100 )edit

Question Tools

1 follower

Stats

Asked: 2013-03-01 20:25:03 +0100

Seen: 28,578 times

Last updated: Mar 02 '13