I'll have to check out the article in TPJ. I understand that excel can open CSV files. You only have to tell it what the delimiters are and select which fields to import. However, this was an oppurtunity for me to write a usefull program that did something other then print "Hello World\n";, if you know what I mean! I especially find it hard to use perl for windows tasks.

This is really one of my first attempts at using perl to parse a file and do something usefull with the data. I'm looking for suggestions on coding style and general improvements on my code.I'm still learning how to properly use regexes and not sure if Im doing things the best way.

As far as the Win32::OLE module, I have looked at the Activestate documents and seen that faq that show how to control Excel. The documentation still leaves me not exactly sure what OLE is and how to use it properly. For example, how do you know which applications can be controlled using OLE and what methods are available through this OLE control? The documentation gives reference on how to find information to controll Microsoft office apps and Lotus notes but falls silenty on all others.

I looked at your script. Not sure what program needs to be installed for access to the OLE, but it does not work on my system.

Thanks for your response!

zzspectrez