I am working on porting MSoffice excel macros on linux. Currently I use wine and i run macros. but i have very big complicated file with very huge macros.
Even my wine is not able to run them
Its getting stuck somewhere.
Can anyone help me out from this?
Any suggestions are really helpful.
Thanks in advance

Not much good news. Personally I think porting is always better than running alien packages on a Linux platform, even if the Wine developers do a wonderful job.

It seems that there is no easy way to convert MSOffice macros to StarBasic. The best document I found so far is here. I can't remember anymore where I found it, sorry.

On the OpenOffice.org site you'll find a lot of information about writing macros in StarBasic. Try to google to "convert macros MsOffice OpenOffice"

BTW, I have a similar problem... I have written some macros in Excel for the people at my Office. However, I don't own a single Window machine anymore. Now everyone can use my macros _but_ meself! I have been considering to write the code in StarBasic, and link to the data in the Excel documents of the other users. But that would mean that I have to maintain code in both MSOffice and StarBasic, which is a very nasty solution. The only way left seems to be to use a language which is common on both platforms, and then access the data in a format which is readable for both. I fear a steep learning curve and a lot of work!

jlinkels

I got the same document yesterday. But, porting as you said is going to be difficult as every single line of code has to be modified. I prefer a tool which does all this. Is there any tool ?

Have you looked at Codeweaver's Cross-Over office? I believe it's supposed to be better than basic Wine.

Its a Proprietery software.
I want something thats opensource.

Well, you have the same problems and dilemma as I have.

I partially solved it by doing some processing in a linux shell, reating a CSV file and import that in Excel.

But another program, which does a lot with borders and colored backgrounds, is still unusable in Linux.

What I do now and then as well is that I VNC to a Windows machine and run the MS app there. Unfortunately VNC proves to be unreliable on some windows machines and refuse to let me in after a few days. Still a nuisance.

I am afraid you have to make the step to something multiplatform someday, or to make the conversion to Linux for once and for all, but I do not know whtether that is possible in your office.

jlinkels

In that case your open source option might be ReactOS.

Crossover is just a nicely packaged version of wine, with it's code going back into the wine project...

So if the macros don't work in wine then they probably won't work much better in crossover...