Ask Your Question

Migrating macro from Excel to LO

asked 2020-02-14 09:33:38 +0100

Stoyan gravatar image

Hello, I need help with migrating macro form Excel to LibreOffice. Does anybody has interest to help?

edit retag flag offensive close merge delete


This is a questions-and-answers site about LibreOffice usage, thus, read these guidelines and ask a good question.

gabix gravatar imagegabix ( 2020-02-14 10:11:08 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-02-14 20:20:00 +0100

tedtorres505 gravatar image

updated 2020-02-21 21:17:16 +0100

I am willing to take a look at it. I have had some success with "adjusting" Excel VBA macros so they will directly run on Libreoffice. There are some pitfalls. But, I'd be happy to take a look. - that is "approach #1" that is, change the VBA code so it runs. (fix XL specific stuff) - "approach #2" is to re-write the code in LO Basic, or another language. I'm not very experienced in that. (but I'm learning)

OK, I looked at the PNG image. Easiest would be to Email me the file at But, looking at the PNG, it seems to me that you may have to re-write the code to Manually search for what you are looking for, just like is done right before the Error. in essence, not to use the built-in Excel search feature.


edit flag offensive delete link more


Hello, Please tell me how to send you the excel file. It is a excel file, where the agents report their visits/calls in customers. First sheet is a kind of "database" with some data for the customers. Second sheet is reporting section, where has a search form from which we look for a customers data in first sheet. Results are in hidden temp sheet. Currently in LO the macro stops with error when trying to assign temp table with search results to search form field to choose a customer. The code is Search_List_Names.RowSource = "name_Search_List" I am sending a screenshot from excel, where the vba macro works.

Thank you and best regards,


Stoyan gravatar imageStoyan ( 2020-02-18 09:22:08 +0100 )edit
Login/Signup to Answer

Question Tools



Asked: 2020-02-14 09:33:38 +0100

Seen: 119 times

Last updated: Feb 21 '20