Open Office to Excel for Macros

Creating a macro - Writing a Script - Using the API

Open Office to Excel for Macros

Postby Myouzik » Sun Jan 31, 2021 1:45 am

Hello! I am trying to build a spreadsheet for a friend, and all of my experience is in Excel ( I've never used Open Office for spreadsheets). Being that I'm currently strapped for cash, I have the free online version of Office 365 so that I can use Excel. I've since come to realize however, that this version will not allow me to write macros (which I need), so I'm trying to find a way around this. My plan is now to try and build most of the sheet using Office 365, then open it in Open Office Calc to add the macros, followed by exporting the sheet as an Excel file so that I can provide him with the Excel sheet which he requested for his business. (Unless I am overthinking it?)

It's been 5 yrs since I last used Excel as I'm in a different business now, but I was at that time I was a "fairly advanced" user I would say... but certainly not at true expert level. As of now however, I'd call myself a "rusty" user! LOL! I had to start a new account here as I cannot recall which of my many email accounts I previously used for this site. So that said, here is my question.

Being that I don't want to do all of that only to find out at the end that it cannot effectively be done, are there any hiccups or restrictions that I will face which will prevent me from doing this as planned? Or is there a better and easier way that I am not aware of?

Thanks so much!
Last edited by MrProgrammer on Sun Jan 31, 2021 1:50 am, edited 1 time in total.
Reason: Moved topic from Calc forum to Macros and UNO API
Myouzik
OpenOffice 4.1.8
MacOS Mohave 10.14.6
Myouzik
 
Posts: 5
Joined: Sun Jan 31, 2021 1:37 am

Re: Open Office to Excel for Macros

Postby robleyd » Sun Jan 31, 2021 2:11 am

Given that MS Office macros do not always play nicely with AOO, there is a strong likelihood that MS Office may not like AOO macros.

If your need is to write MS Office macros, then MS Office is the best tool.
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.4.6.2 (SlackBuild for 6.4.6 by Eric Hameleers) - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 3872
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Open Office to Excel for Macros

Postby Myouzik » Sun Jan 31, 2021 2:39 am

Yikes. Ok thanks.
Myouzik
OpenOffice 4.1.8
MacOS Mohave 10.14.6
Myouzik
 
Posts: 5
Joined: Sun Jan 31, 2021 1:37 am

Re: Open Office to Excel for Macros

Postby FJCC » Sun Jan 31, 2021 2:39 am

I think robleyd is being overly optimistic. I think that if you write macros in OpenOffice and save that document in the Excel format, the macros will be stripped out.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 8059
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Open Office to Excel for Macros

Postby Myouzik » Sun Jan 31, 2021 2:50 am

If I could test that out, I would. But again I only have the free version of Excel I guess I wouldn't be able to see it even if it was not stripped out.
Myouzik
OpenOffice 4.1.8
MacOS Mohave 10.14.6
Myouzik
 
Posts: 5
Joined: Sun Jan 31, 2021 1:37 am

Re: Open Office to Excel for Macros

Postby robleyd » Sun Jan 31, 2021 3:08 am

Perhaps your friend with Excel would let you test?

NB: I have sent you a PM (private message).
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.4.6.2 (SlackBuild for 6.4.6 by Eric Hameleers) - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 3872
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Open Office to Excel for Macros

Postby Myouzik » Sun Jan 31, 2021 3:18 am

Yeah, thought of that. I need to think about that, as I'm not sure I want to do that.
Myouzik
OpenOffice 4.1.8
MacOS Mohave 10.14.6
Myouzik
 
Posts: 5
Joined: Sun Jan 31, 2021 1:37 am

Re: Open Office to Excel for Macros

Postby Mountaineer » Sun Jan 31, 2021 9:46 am

Hello,

reading the following text the support for VBA in Open/LibreOffice is limited: https://wiki.openoffice.org/wiki/VBA_in ... OpenOffice

reading this you can't develop vba-code in LibreOffice and save it back to excel
https://help.libreoffice.org/latest/en- ... ystem=UNIX

I doubt there is any support on ms-side to understand macros from the UNO-universe

So, if you friend needs help he can either use AOO in adfition to MSO or you should develop in excel.

If you want to try macros in AOO/LO: Forget most things you know of the VBA-API. UNO differs a lot.

J.
OpenOffice 3.1 on Windows Vista
Mountaineer
 
Posts: 66
Joined: Sun Sep 06, 2020 8:27 am

Re: Open Office to Excel for Macros

Postby JeJe » Sun Jan 31, 2021 2:23 pm

You might be able to get an old version of MS Office very cheaply on Ebay - I got the 2003 incarnation for almost nothing.
Openoffice 4.1.6
Windows 8
JeJe
Volunteer
 
Posts: 1500
Joined: Wed Mar 09, 2016 2:40 pm

Re: Open Office to Excel for Macros

Postby Myouzik » Sun Jan 31, 2021 8:36 pm

Good call JeJe, thanks! I was actually already looking at that. Great minds...
Myouzik
OpenOffice 4.1.8
MacOS Mohave 10.14.6
Myouzik
 
Posts: 5
Joined: Sun Jan 31, 2021 1:37 am


Return to Macros and UNO API

Who is online

Users browsing this forum: No registered users and 3 guests