Bug#501996: [VBA Support] Poor compatibility
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
Reply to: