Re: [libreoffice-users] Macro issue

2013-10-23 Thread Tom Davies
Hi :) WOW!! I didn't realise the option existed! That is magic and potentially hugely simplifies one problem i have been delaying dealing with : LibreOffice gets more and more awesome the more i find out about it. Many thanks and regards form Tom :) On 22 October 2013 18:48, Johnny

Re: [libreoffice-users] Macro issue

2013-10-22 Thread Andrew Douglas Pitonyak
On 10/22/2013 01:35 AM, Heena Gupta 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

Re: [libreoffice-users] Macro issue

2013-10-22 Thread Tom Davies
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). Since the statements are so simple this time i wonder if it just needs some

Re: [libreoffice-users] Macro issue

2013-10-22 Thread Johnny Rosenberg
2013/10/22 Tom Davies tomdavie...@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

[libreoffice-users] Macro issue

2013-10-21 Thread Heena Gupta
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 =