Joined: 29 Aug 2006
|Posted: Tue Aug 29, 2006 3:38 pm Post subject: auto fixed width.
|i've search the boards and couldn't find the answer. So, heres the deal.
I got text files that need to be imported to a spreadsheet at a fixed width. i've been using Excel for this and had gotten tired of the *click* *click* to set column width.
I knew there were macros for OpenOffice (couldn't use at work; idiot sysadmins) to set fixed width for text files. Now that i work from home i can use OOo. i got the Text2columns macro and it is easyer typing on the numpad to set widths then clicking, but i'm dealing with files that have 400+ rows and there is a 5-6 second delay before i can enter a new number. This makes it take longer then excel, however it hurts the back a hell of a lot less.
my question is. Is there any way that i can set the text2columns macro to 'remember' the 50 some-odd width values?
i only have a little expireance with scripting (can only recognize what some of the code does), but don't have a problem with gitting in and changing it.
oh, and the macro i got was from OOoMacros.org the "Text2Columns - fixed width"