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: "norman.hancock@talktalk.net" <norman.hancock@talktalk.net>
To: users@global.libreoffice.org
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: 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
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.