Solved: Open Office/Excel - Macro Help
I am not an expert in Visual Basic Applications - at all. Your 2 replies have solved both my problems perfectly, it's exactly what I needed Edit: Oh, just one thing, will the morefunc.xll work with Open Office too? EDIT2: The formula CONCATENATE(a1;b1;c1) etc seems to work for the opposite, except for the fact that i'm working with strings 1000 characters long, and CONCATENATE(a1:z100) or whatever doesn't work, it just Board index The team • Delete all board cookies • All times are UTC + 1 hour [ DST ] Forum powered by phpBB © phpBB Group By any use of http://blightysoftware.com/solved-open/solved-open-a-userform-from-a-checkbox-in-excel.html
Tech Support Guy is completely free -- paid for by advertisers and donations. If you're not already familiar with forums, watch our Welcome Guide to get started. Running MS Excel macros on opensource (openoffice or similar) Thilina Randombage asked Oct 12, 2010 | Replies (7) Hi, I have a MS excel workbook with excel macros that I need ekim68 replied Mar 6, 2017 at 11:14 PM Sign of the times ekim68 replied Mar 6, 2017 at 11:12 PM Cool stuff on YouTube #2 ekim68 replied Mar 6, 2017 at
Christo Petkov replied Oct 22, 2010 Hi, If you have installed OpenOffice install BrOffice over it (it is using most of the same libraries). Related Deploy a dynamic, services-oriented cloud for your business Forrester Consulting Report: Empowered Customers Drive ... 7 Stages of IT Monitoring Grief MoreWhitePapers Best Answer 0 Mark this reply as the Check the same thing in BrOffice Equation Editor.
Generated Tue, 07 Mar 2017 04:24:52 GMT by s_za2 (squid/3.5.23) Please let me know if anyone knows a good solution out there. Newer Than: Search this thread only Search this forum only Display results as threads Useful Searches Recent Posts More... Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters.
You're now being signed in. HTH Zack Barresse, Apr 19, 2009 #2 bomb #21 Joined: Jul 1, 2005 Messages: 8,310 "a macro that takes each letter from a string in one cell, and puts each Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... look at this site This site is completely free -- paid for by advertisers and donations.
I lost my OpenSource virginity! Loading... For getting all of the information into one cell, you should download/install the morefunc.xll add-in by Laurent Longre (a google search will lead you there), and then you can use the William Acree replied Oct 12, 2010 OpenOffice.org Calc has supported Excel VBA macros for a while now.
Yes, my password is: Forgot your password? http://ooo-forums.apache.org/en/forum/viewtopic.php?f=20&t=46307 Christo Petkov replied Oct 12, 2010 Hi, broffice.org-calc reads and edits excel files, if you are asking for this. Always respect the original author. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers
The system returned: (22) Invalid argument The remote host or network may be down. this content Join this group Best Answer Updated html error Hi, broffice.org-calc reads and edits excel files, if you are asking for this. Toolbox.com is not affiliated with or endorsed by any company listed at this site. All rights reserved.
This would be an example... =MCONCAT(A1:G1," ") ...where A1:G1 is the range of cells you want to concatenate, and you want to delimit it by a space between each cells value. take all the information from the seperate cells and put it into one string. I ended my career in BASIC in 1978. weblink Board index The team • Delete all board cookies • All times are UTC + 1 hour [ DST ] Forum powered by phpBB © phpBB Group By any use of
You can use a space character as the delimiter and it will put each word into it's own cell. Regards Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... They can't be used with other spreadsheets." bomb #21, Apr 20, 2009 #5 Sponsor This thread has been Locked and is not open to further replies.
I tried OpenOffice but it doesn't run most of the code Appreciate more suggestions.
Thilina Randombage replied Oct 22, 2010 @Christo: I need to be able to run macros on Excel (VBA code) using the opensource alternative as well. @Jalal and @William: Yes. In BrOffice.org Spreadsheet open from the menu: Help -> About BrOffice.org You will find an e-mail for contacts there. JudeWright, Apr 19, 2009 #1 Sponsor Zack Barresse Joined: Jul 25, 2004 Messages: 5,450 Hi there, welcome to the board! Style Default Style Contact Us Help Home Top RSS Terms and Rules Copyright © TechGuy, Inc.
So, open at first BrOffice.org Spreadsheet and write in the command line a simple equation like for example y=x*x (to test whether it supports VBA). Look at Text to Columns on the Data menu. Original answer by Christo Petkov Oct 12, 2010 Contributors: Top Hi, broffice.org-calc reads and edits excel files, if... check over here I'm at school at the moment but as soon as I get home I'll try it.
Thread Status: Not open for further replies. Log In E-mail or User ID Password Keep me signed in Recover Password Create an Account Blogs Discussions CHOOSE A TOPIC Business Intelligence C Languages Cloud Computing Communications Technology CRM All product names are trademarks of their respective companies.