Previous Topic Next Topic

Macro within Open Office Calc

Closed
CMACACKER Posts 2 Registration date Tuesday April 26, 2016 Status Member Last seen May 3, 2016 - Apr 27, 2016 at 03:49 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 10, 2016 at 10:58 AM
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
Related:

3 responses

Answer 1 / 3
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
May 2, 2016 at 11:48 AM
Hi CMACACKER,

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

Best regards,
Trowa
0
Answer 2 / 3
CMACACKER Posts 2 Registration date Tuesday April 26, 2016 Status Member Last seen May 3, 2016
May 3, 2016 at 02:54 PM
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.
0
Answer 3 / 3
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
May 10, 2016 at 10:58 AM
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
0