[Solved] Conversion of Excel 2003 Macros to OOo Format

[SkzDaLimit]

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!

[Villeroy]

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.

[SkzDaLimit]

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.

[Villeroy]

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.

[SkzDaLimit]

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.

[RoryOF]

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

[SkzDaLimit]

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

Thank you!

[kingfisher]

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.

[SkzDaLimit]

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.

[kingfisher]

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.

[SkzDaLimit]

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.

[Villeroy]

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.

[SkzDaLimit]

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.

[mriosv]

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.

[Hagar Delest]

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.