Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.