2010/8/12 Clarke Rice <[email protected]>: > Hi All, > > Does anyone know if there is a way around what I describe below, or should I > report it as a bug. > > Using: OOO 3.2.0 on Win Vista, and also 3.2.1 on Ubuntu 10.04 (same > behaviour in both) and Excel 2007 under windows Vista. > > 1) Macros recorded in Calc and stored in ODF do not import to Excel > (probably Excel's issue, rather than Calc's)
Excel does not understand OpenOffice.org Basic. > > 2) Macros recorded in Calc and stored in XLS files open fine in Calc, but > are not detected by Excel. See 1. > > 3) Macros recorded in Excel and stored as XLS open fine in Calc. However, > if I save changes to the XLS file, Excel cannot see the macros any more. I don't know if OpenOffice.org Calc understand VBA these days, it didn't a while ago anyway. Maybe OpenOffice.org Calc converts VBA to OpenOffice.org Basic somehow, and then Excel can't understand them, see 1 and 2. Regards Johnny Rosenberg > > Best wishes, > > Clarke > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
