Hi, . I know you can run Windows applications using WINE (winehq.com), but has anyone tried, say, running Word or Excel VBA code/macros based on Windows run time libraries? . the thing is that in their faq (winehq.com/site/docs/wine-faq/index) they don't even mention this possibility and searching on; VBA Word, doesn't give you any hits, even though WINE does link to windows native dll's . Perhaps anyone hasn't tried that yet. Perhaps I haven't looked in the right place . Could you point me to examples/tutorials? . thanks lbrtchx
Albretch Mueller wrote:> Hi, > . > I know you can run Windows applications using WINE (winehq.com), but has > anyone tried, say, running Word or Excel VBA code/macros based on Windows > run time libraries? > . > the thing is that in their faq > (winehq.com/site/docs/wine-faq/index) they don't even mention > this possibility and searching on; VBA Word, doesn't give you any hits, > even though WINE does link to windows native dll's > . > Perhaps anyone hasn't tried that yet. Perhaps I haven't looked in the > right > place > . > Could you point me to examples/tutorials?Albretch, Firstly, I have disabled the automatic email response to you as I believe it is rude to ask for help here and want any answers or further discussion sent to you by email! Back to your question. Yes, VBA code can be run under MS Office products under WINE - I did so some time ago. The problem is that I have tried more recently and the macros did *not* run reliably [with Word 97/Excel 97]. It is possible that the original test was done under an evaluation copy of the CrossOffice product environment - a commercial version of WINE optimised mainly for MS Office products - I really cannot remember as it was a few years ago :( I'd suggest you try to get VBA & Word/Excel to run under a recent version of WINE before you look elsewhere. As well, I used a product called winetools to help set up the WINE environment - greatly simplifies the process, but it's a bit long in the tooth and apparently has problems in some areas. I believe that there was a new project (wine doors) set up to effectively replace winetools, but I'm not sure what has happended since I last looked - at least 6 months ago. A few sites to look at re WINE setup if you need them (not VBA specific AFAIK): wine-doors.org/trac von-thadden.de/Joachim/WineTools sidenet.ddo.jp/winetips frankscorner.org/index.php?p=ie6 mc1soft.com/linux/index.html HTH Rob.
there was a recent post in digg.com, i only looked superficially at it, but it said something about openoffice.org was going to add support to VBA, and since OO.o is supported in linux, then it may be possible to run your macros in oppenoffice.calc -- --- zz [MX] cuasi-musico,semi-poeta y loco "Albretch Mueller" <lbrtchx@hotmail.com> wrote in message news:1166514775.417080@nntp.acecape.com...> Hi, > . > I know you can run Windows applications using WINE (winehq.com), but has > anyone tried, say, running Word or Excel VBA code/macros based on Windows > run time libraries? > . > the thing is that in their faq > (winehq.com/site/docs/wine-faq/index) they don't even mention > this possibility and searching on; VBA Word, doesn't give you any hits, > even though WINE does link to windows native dll's > . > Perhaps anyone hasn't tried that yet. Perhaps I haven't looked in the > right > place > . > Could you point me to examples/tutorials? > . > thanks > lbrtchx
> it may be possible to run your macros in oppenoffice.calcI was thinking more of Word macros, not Excel ones . lbrtchx
Hi Albretch, If Word and Excel can run in this environment, then I'd expect any macros that manipulate the applications' automation interfaces would work, as well... If you're asking about using the Windows APIs through VBA code, then the answer would be that the same thing would happen as with any other code that works with the Windows APIs (Visual Basic, for example).> I know you can run Windows applications using WINE (winehq.com), but has > anyone tried, say, running Word or Excel VBA code/macros based on Windows > run time libraries? > .. > the thing is that in their faq > (winehq.com/site/docs/wine-faq/index) they don't even mention > this possibility and searching on; VBA Word, doesn't give you any hits, > even though WINE does link to windows native dll's > .. > Perhaps anyone hasn't tried that yet. Perhaps I haven't looked in the right > place > .. > Could you point me to examples/tutorials? >Cindy Meister INTER-Solutions, Switzerland homepage.swissonline.ch/cindymeister (last update Jun 17 2005) word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-)