You can try the macro recorder which requires no programming skill. Assuming the input is a text file with comma delimited fields, rename it to filename.csv.
Now turn on the recorder and do the actions of reading the file, indicating comma delimited, insert formulas, create graphs, and turn the recorder off. -- Dennis Disclaimer: The above is my opinion. I do not guarantee it. Be sure to back up any files involved and use at your own risk. "Robert Citek" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > Hello all, > > On a project I'm currently working at work, we take a bunch of comma- > separated files, load them into separate sheets within Excel, perform > some calculations, and generate some graphs. We are thinking of > automating the process using VBA, except that none of use really knows > VBA. So rather than learning VBA which only runs on Windows, we thought > we might better spend our time learning whatever works best with OOo. > > Can the above process be automated with OOo? If so, how? Where should > we be looking? Our knowledge-base includes perl, python, bash, awk, > Java, lisp, BASIC, and C. Of course, we're up for learning any new > languages if it will help us with OOo. > > Thanks in advance for any pointers. > > Regards, > - Robert > http://www.cwelug.org/downloads > Help others get OpenSource software. Distribute FLOSS > for Windows, Linux, *BSD, and MacOS X with BitTorrent --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
