Macro within Open Office Calc [Closed]

Report
Posts
2
Registration date
Tuesday April 26, 2016
Status
Member
Last seen
May 3, 2016
-
TrowaD
Posts
2599
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
March 24, 2020
-
I am having trouble with making a code do what I want. I am trying to get a workbook with multiple sheets working in this way. if I have a main sheet and I add data to it I want the data I add to it to populate other sheets within that workbook based on what I type in a single column.

I have successfully made it work based off of a code provided in another thread for excel but I cannot get the same concept to work within open office calc.

Any suggestions? or code examples/solutions would be fantastic.

Thanks in advance,

CMACACKER

3 replies

Posts
2599
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
March 24, 2020
401
Hi CMACACKER,

Is this about the query you send a private message about?

Best regards,
Trowa
Posts
2
Registration date
Tuesday April 26, 2016
Status
Member
Last seen
May 3, 2016

TrowaD,

Yes it is. :)


I tried the code you supplied in your reply, plugging in data where it should be and for some reason I am still getting a syntax error.
Posts
2599
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
March 24, 2020
401
Hi CMACACKER,

Well I tested the code and it works for me, so it must be something to do with Open Office.

VBA and open office aren't the best of friends:
https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=39990

What you can try is using this converter to change VBA code to Open Office code:
https://www.business-spreadsheets.com/vba2oo.asp

No idea if it would work but it's worth a try.

Best regards,
Trowa