Excel macro conversion

Creating a macro - Writing a Script - Using the API

Excel macro conversion

Postby NoelChestnut » Sat Jul 08, 2017 9:26 pm

Book1.xlsm
(21.88 KiB) Downloaded 30 times
Hello,

I'm hoping that someone can help with this.

I'm trying to get this to work in Calc however I'm having no luck at all.

Can anyone make it work?

Many thanks

Title Edited. A descriptive title for posts helps others who are searching for solutions and increases the chances of a reply (Hagar, Moderator).
OpenOffice 5.2 in Windows 10
NoelChestnut
 
Posts: 2
Joined: Sat Jul 08, 2017 9:07 pm

Re: Beginner Help

Postby FJCC » Sat Jul 08, 2017 9:36 pm

Only very simple macros can be ported from Excel to OpenOffice or LibreOffice. LibreOffice has better compatibility with Excel macros but judging from your signature, you are already using that. If you really need to run this in Calc, you need to rewrite it.
AOO 3.4 or 4.1 on MS Windows XP ( before 2013-08-03) or Windows 7
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: 6169
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Beginner Help

Postby NoelChestnut » Sat Jul 08, 2017 10:09 pm

Yeah I've figured that part out, I am really struggling though hence why I'm here, there doesn't seem to be an abundance of guides/help etc available. Is there anything that could recommend that would help me?
OpenOffice 5.2 in Windows 10
NoelChestnut
 
Posts: 2
Joined: Sat Jul 08, 2017 9:07 pm

Re: Excel macro conversion

Postby FJCC » Sat Jul 08, 2017 11:02 pm

The best resources I know of concerning macros are by Andrew Pitonyak.
You might also consider doing this in a database using the Base component of OpenOffice. That also requires a lot of learning but, if I understand what the macro does, it is the appropriate tool. There is a good Base tutorial here.
AOO 3.4 or 4.1 on MS Windows XP ( before 2013-08-03) or Windows 7
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: 6169
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Excel macro conversion

Postby MrLumme » Mon Jul 10, 2017 3:14 pm

You could rename it from 'xlsm' to 'xlsx'. I haven't hit any problems doing that yet.

Edit: Also note that if you do this, Microsoft Office will call the file corrupt, but OpenOffice will be fine with it.
OpenOffice 4.1.3, win7 & win10
MrLumme
 
Posts: 4
Joined: Mon Jul 10, 2017 3:10 pm


Return to Macros and UNO API

Who is online

Users browsing this forum: No registered users and 9 guests