I believe that a sample solution can be found in AndrewBase.odt, search
for the macro listing "Prompt for a CSV file, and then display the data."
On 03/06/2012 06:35 PM, fork wrote:
Hi all,
First of all, thanks to all for such a great product!
Second, I would like to write, record, or copy a macro for calc that opens a
tab delimited file and sets all the imported columns to be text format. I want
it to give me a file selection dialogue, but otherwise do everything else
automatically.
I know how to do this manually, and it isn't tricky, it is just that we have
LOTS of tab delimited text data files here at work, and it would awesome to be
able to push a button, choose a file, and voila.
Since I have already chosen not to have LO prompt if saving in non-ODT, this
would work seamlessly, saving me endless hours of fury at Excel for their stupid
"you will lose formatting" blather.
I can provide any more info if anyone would like.
P.S. -- I don't really want to get good at macro writing, so I am hoping for the
very quickest quick hack, rather than the 500 page introduction to LO Basic. No
judgements implied, just expediency.
Tx!
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info: http://www.pitonyak.org/oo.php
--
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
