[Solved] Conversion of Excel 2003 Macros to OOo Format

Discuss the spreadsheet application

[Solved] Conversion of Excel 2003 Macros to OOo Format

Postby SkzDaLimit » Mon Dec 26, 2011 11:08 pm

Greetings and salutations!

I just recently started using the OpenOffice Suite and I have to say I am really impressed. My kids have even taken a liking to it and have been using it instead of Excel, Word, etc..... My question to anyone who might be willing to help is concerning getting macros from an Excel spreadsheet to operate properly in OO. I am not a programmer or anything and my knowledge is pretty limited. The macro I have is one that I modified from a spreadsheet I found on the internet and after many weeks or hair pulling and headaches, managed to actually get to work perfectly. If someone could possibly tinker with this and see what they could do, it would be much appreciated. I learn best looking at examples of the same concept in 2 different formats and I can see the differences and piece it all together.

Many thanks again if someone can assist me with this!
Last edited by Hagar Delest on Tue Dec 27, 2011 11:47 am, edited 2 times in total.
Reason: tagged solved
- Michael (SkzDaLimit)
OpenOffice 3.3.0 on Windows XP Pro
SkzDaLimit
 
Posts: 7
Joined: Mon Dec 26, 2011 10:53 pm

Re: Conversion of Excel 2003 Macros to OpenOffice Format

Postby Villeroy » Mon Dec 26, 2011 11:47 pm

This is not a question of formatting and there is no magic switch "Pretend to be Excel". You have to write another program talking to this program just like you wrote a program that talks to MS Excel.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 25275
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Conversion of Excel 2003 Macros to OpenOffice Format

Postby SkzDaLimit » Mon Dec 26, 2011 11:59 pm

Villeroy wrote:This is not a question of formatting and there is no magic switch "Pretend to be Excel". You have to write another program talking to this program just like you wrote a program that talks to MS Excel.


Judging from your reply, I think you are completely misunderstanding my request for assistance. Looks like I might have picked the wrong place to try and get some help. Thanks. :crazy:
- Michael (SkzDaLimit)
OpenOffice 3.3.0 on Windows XP Pro
SkzDaLimit
 
Posts: 7
Joined: Mon Dec 26, 2011 10:53 pm

Re: Conversion of Excel 2003 Macros to OpenOffice Format

Postby Villeroy » Tue Dec 27, 2011 12:17 am

Oh, after all those years I understand very well. What your silly macro does can be done in any spreadsheet program by mean of ordinary formulas.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 25275
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Conversion of Excel 2003 Macros to OpenOffice Format

Postby SkzDaLimit » Tue Dec 27, 2011 12:43 am

You know what? I didn't come here to be insulted by you or anyone else for that matter.

#1 - You don't know what my macro does so I do not think you have the right to tell me that something is silly, impractical or otherwise.
#2 - For the purpose I use it in, it has to be a macro. Understand now?
#3 - For someone who has 11K posts in this forum, I would think that you would be a bit more understanding and less offending to newcomers.

I came here looking for help and advice. Not to be belittled and insulted by the likes of you. If this forum is nothing but people like yourself, it's no wonder this world has turned to crap. I'll seek my answers elsewhere.

Thanks for nothing. Good day.
- Michael (SkzDaLimit)
OpenOffice 3.3.0 on Windows XP Pro
SkzDaLimit
 
Posts: 7
Joined: Mon Dec 26, 2011 10:53 pm

Re: Conversion of Excel 2003 Macros to OpenOffice Format

Postby RoryOF » Tue Dec 27, 2011 1:27 am

Start with
http://www.pitonyak.org/AndrewMacro.odt
You have to learn a completely different syntax from that used by Excel.
Apache OpenOffice 4.1.5 on Xubuntu 18.04 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
RoryOF
Moderator
 
Posts: 26537
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Conversion of Excel 2003 Macros to OpenOffice Format

Postby SkzDaLimit » Tue Dec 27, 2011 1:30 am

RoryOF wrote:Start with
http://www.pitonyak.org/AndrewMacro.odt
You have to learn a completely different syntax from that used by Excel.


Thank you! :D
- Michael (SkzDaLimit)
OpenOffice 3.3.0 on Windows XP Pro
SkzDaLimit
 
Posts: 7
Joined: Mon Dec 26, 2011 10:53 pm

Re: Conversion of Excel 2003 Macros to OpenOffice Format

Postby kingfisher » Tue Dec 27, 2011 2:50 am

If, as I suspect, you discover that Writer is a bad reader, you can get a pdf form of the document from this page.

It would help some of us if you explain what you want to achieve. If anyone knows that macros are not required, Villeroy does. To get help from Calc users who are not coders or are not familiar with Microsoft's coding language, you need to spell out the desired outcome.
Apache OpenOffice 4.1.2 (64 bit) on PCLinuxOS
User avatar
kingfisher
Volunteer
 
Posts: 2109
Joined: Tue Nov 20, 2007 10:53 am

Re: Conversion of Excel 2003 Macros to OpenOffice Format

Postby SkzDaLimit » Tue Dec 27, 2011 3:24 am

kingfisher wrote:If, as I suspect, you discover that Writer is a bad reader, you can get a pdf form of the document from this page.

It would help some of us if you explain what you want to achieve. If anyone knows that macros are not required, Villeroy does. To get help from Calc users who are not coders or are not familiar with Microsoft's coding language, you need to spell out the desired outcome.


Thanks for the extra linkage!

The reason I use a macro as opposed to just a series of formulas is I am able to lock the code from being seen and/or copied by anyone. The macro is used in a spreadsheet I have been selling on eBay that is used by other sellers to track sales and profits. The macro itself calculates the final value, shipping and PayPal fees for each transaction based on the type of category an item sold falls under and places that value in an assigned cell in the worksheet. Using a formula would make it easy for someone to just copy the code and then make their own spreadsheet and try to sell it.

And yes, I know it's probably a bit risky to post the macro code here but I trust there are more honest people with integrity than there are dishonest people.

As for Villeroy, I am over that incident though I still feel his comments were unwarranted.
- Michael (SkzDaLimit)
OpenOffice 3.3.0 on Windows XP Pro
SkzDaLimit
 
Posts: 7
Joined: Mon Dec 26, 2011 10:53 pm

Re: Conversion of Excel 2003 Macros to OpenOffice Format

Postby kingfisher » Tue Dec 27, 2011 4:29 am

Using the ods format will suit potential buyers who do not have MS Office. It is unlikely to be used by anyone who has that software.

You have posted your code on a public page. I have read the posts in this thread on Google Reader.
Apache OpenOffice 4.1.2 (64 bit) on PCLinuxOS
User avatar
kingfisher
Volunteer
 
Posts: 2109
Joined: Tue Nov 20, 2007 10:53 am

Re: Conversion of Excel 2003 Macros to OpenOffice Format

Postby SkzDaLimit » Tue Dec 27, 2011 4:45 am

kingfisher wrote:Using the ods format will suit potential buyers who do not have MS Office. It is unlikely to be used by anyone who has that software.

You have posted your code on a public page. I have read the posts in this thread on Google Reader.


That is my thought as well so I'll look at those docs from the links provided. Edited my original post and removed the macro code as well.
- Michael (SkzDaLimit)
OpenOffice 3.3.0 on Windows XP Pro
SkzDaLimit
 
Posts: 7
Joined: Mon Dec 26, 2011 10:53 pm

Re: [Solved] Conversion of Excel 2003 Macros to OOo Format

Postby Villeroy » Tue Dec 27, 2011 8:26 pm

Using a formula would make it easy for someone to just copy the code and then make their own spreadsheet and try to sell it.

The macro and the required formula to replace the macro is as trivial as a screw driver. It is the most fundamental matter of course when you start using spreadsheets with a little bit more than a sum formula.
Resembling the hidden functionality or extracting the macro from the document is trivial as well.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 25275
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: [Solved] Conversion of Excel 2003 Macros to OOo Format

Postby SkzDaLimit » Tue Dec 27, 2011 11:14 pm

Villeroy wrote:
Using a formula would make it easy for someone to just copy the code and then make their own spreadsheet and try to sell it.

The macro and the required formula to replace the macro is as trivial as a screw driver. It is the most fundamental matter of course when you start using spreadsheets with a little bit more than a sum formula.
Resembling the hidden functionality or extracting the macro from the document is trivial as well.


I appreciate your comments and everything but protecting my "intellectual property" is not a trivial matter. I own and run a business on eBay as well as run a business out of my home. I value the time I have put into my creative efforts and while I do not mind people using that which I have created, I do mind when ones works are taken and exploited by cons and thieves. That's part of what Capitalism is all about. Not the Socialist ideas most of you Europeans believe in.... taking whatever you want and then giving it all who feel they are "entitled" to it.

Anyways, can a moderator PLEASE close or lock this thread down from further comment. I got the information I need and am well on my way to figuring this all out on my own. Many thanks to those who pointed me in the right direction without the need for criticism and badgering.
- Michael (SkzDaLimit)
OpenOffice 3.3.0 on Windows XP Pro
SkzDaLimit
 
Posts: 7
Joined: Mon Dec 26, 2011 10:53 pm

Re: [Solved] Conversion of Excel 2003 Macros to OOo Format

Postby mriosv » Tue Dec 27, 2011 11:49 pm

And you can come here, to get from us make your business for less than nothing, by your insults. Really a hard face.
Please open your mind.
There is a section in the forum: Board index ‹ Business ‹ Paid support.
LibreOffice 3.5.4 AOo-3.4 on Win 7 Ultimate
mriosv
Volunteer
 
Posts: 651
Joined: Mon Mar 09, 2009 1:12 am
Location: Galiza (España)

Re: [Solved] Conversion of Excel 2003 Macros to OOo Format

Postby Hagar Delest » Wed Dec 28, 2011 12:24 am

SkzDaLimit wrote:I do mind when ones works are taken and exploited by cons and thieves. That's part of what Capitalism is all about. Not the Socialist ideas most of you Europeans believe in.... taking whatever you want and then giving it all who feel they are "entitled" to it.

Your clichés are not welcomed here.

I lock the thread but not for the reasons you've given. People helping here have better to do than losing their time in this topic.
AOO 4.1.5 on Xubuntu 18.04 and on Windows 7 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28044
Joined: Sun Oct 07, 2007 9:07 pm
Location: France


Return to Calc

Who is online

Users browsing this forum: No registered users and 37 guests