On 19/12/2007, Anthony Chilco <[EMAIL PROTECTED]> wrote: > > Hi Anand, > The current version of OOo doesn't run Excel VB macros. Novell has a > version > that will run some macros, depending on the functions that have been used. > The > macros in the file you've posted are password protected in Excel, so I > can't > have a look at them to see how complex they are. You can try downloading > and > installing the Novell version and see if it works. > tc > > Anand Khandewale wrote: > > I have uploaded the file on yousendit and the same is available at the > > following link - > > > > Link: http://download.yousendit.com/F41F1B1F2D38E43D > >
<snip> Anthony, What makes you think they are password protected? My OO 2.2 on Win XP Pro *seems* to open the .xls file and I can edit the macros via Tools>Macros>Organise. I'm *not* asked for any passwords. Is OO hiding stuff from me that I'd see if it wasn't password protected or what? Anand, Anthony's point about VB is, of course, correct. If the Novell version can't handle your macros you'll either have to doctor your VB till it can, or rewrite them in OpenOffice Basic (or one of the other languages OO supports which, I think, include Python and JavaScript) -- Harold Fuchs London, England Please reply *only* to [email protected]
