Hi :) Ahah, yes, macros are not usually able to work on both MS Office and LibreOffice. They have to be written (or recorded) on one or other and then seldom work on the other.
With MS macros you may well find they don't even work in other versions of MS Office. So if your macros were written/recorded in MS Office 2007 then they may well not work in MS Office 2010 until they get converted and then you can't go back to 2007 with them. LibreOffice macros just work regardless of which version. It's worth noting that LibreOffice is free and can also be run as a "portable app" installed on a usb-stick or on a Cloud storage place and then run without really properly installing it on whichever machine you need to run it on. When you disconnect from the Cloud or unplug the usb-stick then that machine no longer has LibreOffice on it. There are a number of other apps (such as Firefox, Thunderbird and others) that can all be on the same usb-stick and used on any machine the usb-stick is plugged into (assuming it runs Windows) http://www.libreoffice.org/download/portable/ Another thing that people often don't consider is that it is perfectly fine to have LibreOffice installed on the same machine as MS Office, or to install MS Office onto a machine that already has LibreOffice. You don't HAVE to get rid of one in order to run the other. In fact this is often the suggested route for gradually migrating. Have both. [shrugs] Then you can open all documents from anyone in any format rather than just hoping you are not going to find one of the 0.25% of documents in MS format that doesn't work in LibreOffice. Another thing that is often down-played by MS is that most of their licenses for their office suite allows you to install it on 2-3 machines. Many people have more than 1 machine at home if you count laptops and the rest and MS finally caved in about archaic restrictions. So the main trouble is trying to get install media to get it onto the laptop but once you do that the same product key should work. I'm sure i shouldn't be saying that but i do hope you continue with LibreOffice. Good luck and regards from Tom :) >________________________________ > From: "[email protected]" <[email protected]> >To: [email protected] >Sent: Thursday, 14 February 2013, 14:45 >Subject: [libreoffice-users] LibreOffice V 3.6.5.2 (build ID: 5b93205) > >Sirs >I am at the moment running Microsoft Office on my desktop computer (XP) and >have just purchased a new laptop (Windows 7) onto which I have downloaded the >above LibreOffice. I wish to ensure that the documents I already have on the >XP machine can safely be read, changed in Calc & written back before I change >my desktop machine to LibreOffice also. However I have 2 problems that need >resolving, both to do with Macros. > >1. When I load an Excel document containing macros into Calc, the macros >(assigned to buttons on the worksheet) work OK, but when I make changes to the >document and then save it in xls format the macros no longer work in Excel as >the path to the macros seems to have been changed. I can go into the macros, >change the path and make them work again but this is by no means satisfactory. >Other people use my files so my changing to LibreOffice on the desktop m/c >will not help them. Any clues anyone? > >2. These same documents may require me to record new macros so I searched your >Help files for information on how to do this and came across problem 2. The >help file says to click on 'Tools/Macros/Record Macros', however when I >checked this I find there is no 'Record Macros' choice, only 'Run Macros'. Is >your help file wrong or am I missing something? > >Other than the above, I think that LibreOffice is brilliant and can't wait to >install it on my desktop m/c. > >Regards > >Norman Hancock >-- >For unsubscribe instructions e-mail to: [email protected] >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: [email protected] 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
