Terry wrote:
Someone recently published script to export all files of a folder to a
csv. The script contains a loop to save all sheets of each file to a
.csv. I have not used it myself.
http://www.oooforum.org/forum/viewtopic.phtml?p=194938#194938
That looks great, thanks. I've not got into ooBasic yet but this looks
like a good opportunity to try it!
It would be desirable if you could use the export command for a .csv,
just as the published script uses the method storeToUrl which means that
the file being exported remains. The .csv files are saved but are not
open.
Yes it would; this is my biggest problem; I have on too many occasions
saved as CSV then continued working on the file and saving it, only to
realise later that I've been rewriting my CSV each time and not the
original document. At least OOo does warn me only the active sheet is
saved and that's a good reminder, but when you do something often enough
its easy to start ignoring messages. If you don't catch this before you
close the document you can lose a *lot* of work in unsaved sheets.
Also, if the .CSV files are not stored in the same location as the
original spreadsheet there's a lot of navigating between directories to
re-open the old file (since a save-as does not leave the old file in the
file history).
--
Mark Rogers
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
