Noel Power wrote: > Hi Renato Hi Noel! Is good to know that you see my problem :-)
> Sorry to hear that you document doesn't run with our VBA support. The > VBA api is vast, we haven't replicated every piece of VBA functionality > or every API object. I hate VBA, but this kind of code is used in a lot of companies. This sample file attached in Debian Bug Report #501996 is a great example (I received it from a big client): <http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=501996> > Your document contains nearly 1000 lines of macro code, so it > would be great if you could identify the smallest segments that don't > work and relay that information to us ( or me if you like ) as small > stand alone macros to demonstrate the problems. And other problem: This macro is not made by me, but I need use it :-( Some instructions are in "Instructions" sheet and maybe can be useful. > Knowing where the > failures are will influence what we set about to fix next. Additionally > it might be possible to rewrite a non functioning macro so it will work > in openoffice and MSO, but to give such advice one also needs to know > where things are failing > > Are you interested in helping? *Of course* I would like to help :-) > btw I followed the steps in the bug you fwded to the list, it appears > that part of the problem here is that Calc itself doesn't support named > ranges at the sheet level, named ranges have a global scope in > openoffice, this leads to some inconsistency in the imported data ( and > hence errors in the vba attempting to use those ranges ) I did change > the named range "Tooling_Operation_Description" on sheet e-1810_A to > Tooling_Operation_Description_New ( and changed the macro code to use > that too ) and the steps you describe now seem to work ( but perhaps > other things don't ) I go to Tools --> Macro --> Manager Macros --> OOo Basic and click in Edit. I changed all Tooling_Operation_Description to Tooling_Operation_Description_New (only 2 is found and replaced). But I give this error: Type: com.sun.star.uno.RuntimeException Message: . Macro Basic is opened and show me this line error: Set TOP = Worksheets("e-1810_A").Range("Tooling_Operation_Description_New") Best regards, Renato -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
