Re: [libreoffice-users] Macro Security Settings

2013/3/9 Andrew <apb5653@bak.rr.com>:
> On 3/9/2013 11:56 AM, Johnny Rosenberg wrote:
> > 2013/3/9 Andrew <apb5653@bak.rr.com>:
> > > Version 3.6.5.2 (Build ID: 5b93205)
> > >
> > > I wrote a program? macro? many years ago in Excel 2000 that I haven't
> > > used
> > > in almost as long, but now I have need of it again.
> > >
> > > When I try to run it, Libre Calc complains about the security settings.
> > > I
> > > changed them in tools->options-->LibreOffice--->Security-->Macro Security
> > > to
> > > "Low" and it still gives me the same error and refuses to run the macro.
> >
> > Did you restart LibreOffice after changing that setting?
>
>
> I did not.  And that has resolved the problem.  Thank you!
>
> I now have the problem Miroslaw has already commented on - star office vs.
> VBA.  Ouch.   I've received "Basic runtime error 1". Is there a translation
> guide?

I'm not sure, I don't think so. I have never tried to load an Excel
macro in LibreOffice and I didn't use Excel since I don't know when,
2006?
Does it look like LibreOffice has tried to translate the macro somehow
or does it look exactly like the original Excel macro?
What does the line look like that currently is producing an error? Are
there many lines like that?

Andrew Pitonyak's macro document is a good start if you want to learn
LibreOffice Basic macro programming. Search for AndrewMacro and you
will find a PDF and an ODF (same document, different formats).
Installing something called ”xray” is also a very good idea. It's a
macro that helps you investigate objects, for example cell ranges,
selections and much more.
If you just want to know a couple of simple things, like how to get
and set properties for a cell range, you can ask here if you can't
find the answer by searching.


Johnny Rosenberg

> This is not just a simple one line macro, this is a program of relatively
> large proportion - I estimate hundreds of lines of code. And I have others I
> will probably need to do the same.
>
> By the way, it sure would be nice if I could copy & paste error messages
> directly from the error dialogs (the same way I was able to copy & paste the
> version string), instead of having to retype them.
>
> Thank you
>
>
>
> --
> For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted