Re: [libreoffice-users] Macro issue

2013/10/22 Tom Davies <TomDavies04@yahoo.co.uk>

> Hi :)
> It is interesting that it works at all!  LibreOffice uses a slightly
> different programming language for it's macros so often people have to
> translate the MS ones into LibreOffice Basic (or Python or whatever else).

Maybe ”Option VBASupport 1” has something to do with it?


Johnny Rosenberg


> Since the statements are so simple this time i wonder if it just needs some
> tweaking or needs to be copy&pasted into a fresh new macro or something?
> Hopefully someone on this list will be able to give you a much better
> answer!
> Good luck and regards from
> Tom :)
>
>
> On 22 October 2013 06:35, Heena Gupta <rush2hina@gmail.com> wrote:
>
> > Hi guys,
> >
> >  When i run the MS Excel macro in libre office, it runs correctly but
> shows
> > the output while clicking on the cell on which output comes.
> >
> >
> > Option VBASupport 1
> > Sub Button1_Click()
> > Dim a As Integer
> > Dim b As Integer
> > Dim c As Integer
> > Range("B1").Select
> > a = ActiveCell.Text
> > Range("B3").Select
> > b = ActiveCell.Text
> > c = a + b
> > Range("B8").Select
> > ActiveCell.FormulaR1C1 = c
> > End Sub
> >
> > Thanks & Regards,
> >  Heena Gupta
> >
> > --
> > To unsubscribe e-mail to: users+unsubscribe@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
>
> --
> To unsubscribe e-mail to: users+unsubscribe@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

-- 
To unsubscribe e-mail to: users+unsubscribe@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