Previous Topic Next Topic

Macro within Open Office Calc

Closed
CMACACKER Posts 2 Registration date Tuesday 26 April 2016 Status Member Last seen 3 May 2016 - 27 Apr 2016 à 15:49
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 10 May 2016 à 10:58
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

Réponse 1 / 3
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
2 May 2016 à 11:48
Hi CMACACKER,

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

Best regards,
Trowa
Réponse 2 / 3
CMACACKER Posts 2 Registration date Tuesday 26 April 2016 Status Member Last seen 3 May 2016
3 May 2016 à 14:54
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.
Réponse 3 / 3
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
10 May 2016 à 10:58
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