Dan Lewis wrote: > > On Saturday February 24 2007 1:24 pm, Gerald Glass wrote: >> I am using Openoffice ver. 2.1 and I cannot get a excell >> spreadsheet to work in Calc format. It is a spread sheet that I use >> in my business quite frequently. I obtained the spread sheet from a >> vendor for doing a specific job. When I convert it to openoffice, >> it does not calculate correctly when the macros are enabled. I am >> attaching the spread sheet in excell format. The problem is in the >> formula in D10. Any help will be appreciated. Gerald Glass >> [EMAIL PROTECTED] > > Attachments are stripped from emails to prevent the spread of > viruses and trojan horses to the members of this list. > At the present time, Calc will not run macros written in VBA. It > uses Star Basic which is similar. Parts of the macro will have to be > rewritten for it to work in Calc. Formulas are not always written the > same either. > If we knew what formula was in D10 and what you wanted it to do, > someone one this list probably could tell you what the correct > formula should be. Changing the formula could solve your problem. > > Dan > > I understand that the Novell version of OOo will run VBA macros. Otherwise, check the following thread, especially the section headed "VBA": http://www.oooforum.org/forum/viewtopic.phtml?t=50952 As Dan says, there may be a function in Calc to replace the one you have lost, although I have seen no evidence that Calc is ahead in that area. You need to explain what the function does. -- View this message in context: http://www.nabble.com/Excell-Macros-won%27t-work-tf3547738.html#a9911132 Sent from the openoffice - users mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
