Ask Your Question
0

Migrating macro from Excel to LO

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

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

Comments

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 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

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

tedtorres505 gravatar image

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

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 TedTorres@juno.com 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.

Ted

edit flag offensive delete link more

Comments

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. https://we.tl/t-WcqPMlm28J

Thank you and best regards,

Stoyan

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

Question Tools

2 followers

Stats

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

Seen: 53 times

Last updated: Feb 21