Terry wrote:
CarlP wrote:
CarlP wrote:
I was sure that OOo 2 was supposed to have incorporated
text-to-column functionality in Calc instead of having to install the
macro (which I haven't been able to get to work properly). But a
quick scan of archives seems to suggest you do still have to install
the macro. Is that right, or is there another way to split one
column in a spreadsheet into multiple columns based on comma, quote,
space, or other characters? This would be a VERY helpful feature...
Carl
BTW, I have the latest macro package but still cannot figure out how
to load it. Anthony Chilco kindly sent some instructions a while ago,
but that was for an earlier version, and unfortunately his
instructions didn't match my screen options, and everything I tried
failed.
Please help me understand how to install this macro as it's an
important feature for me.
Thanks and happy holidays!
Carl
Put the downloaded file somewhere it can stay. Then use Tools >Package
Manager. That's it.
The Tools menu will acquire another branch, "Add-Ons" and "Text to
Columns" will be in that branch. The Help menu will acquire "About text
to columns". You may have to re-start OOo to get those changes.
Thanks for the suggestion, but I've never run the package manager
before, and when I try, I can select Add for "My Packages" but then the
download folders don't contain anything that looks like a package to me.
If I select some of the xba scripts in the Text-To-Columns folder of
the download, I get an error "cannot detect media type."
Now, after doing something to try to install the macro (I can't recall
what I did), I now have a library under My Macros with three routines in
it that have the same names as the macros in the download file (there
are a ton of other xba scripts in the download, none of which are
available in my libraries). I've tried running the one called Main,
which I think was the one to select when you want to run the
Text-To-Columns macro, but when I do that, it chokes with the following
highlighted:
If IsCellRangeEmpty(oSelection) Then
The error is a BASIC subroutine error with "sub-procedure or function
procedure not defined"
I've selected the cells in the column I want to run the macro on, so
that can't be the problem. It sounds like it could be a missing
sub-routine, but I can't figure out what, nor how to get it from the
download set since I can't figure out what I did to get the three
routines into My Macros in the first place.
Now, I'm reasonably talented with computers, software, databases, etc.
and can do some simple programming, and I'm committed to working with
OOo, but this process of installing macros is VERY confusing to me...
Carl
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
