Or you can use a PERL script to take a File that is delimited by @AM (rows) and @VM (columns) and create an XLS binary file. I currently do this on an HPUX 11.x running Unidata 6.X. Did I mention it was free?
Email me offline if you would like details. Thanks, * Please NOTE NEW ADDRESS AND TELELPHONE Numbers * -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 5901 Broken Sound Parkway NW, Suite 450 Boca Raton, FL 33487 USA Voice Phone: 561.226.8261 Fax Phone: 561.226.8115 >>> [EMAIL PROTECTED] 2:45 pm 01/13/2006 >>> Our UV system creates an ASCII .csv file for another system to import on a daily basis. The 3rd party software after a recent upgrade now only imports .xls files. Is there an easy way to "automate" Excel to load the .csv, then save as .xls? Or how much more difficult is it to create the .xls instead of a .csv? I thought about getting one of those programs that records mouse clicks, and create a macro of the conversion (since the filename is the same each day), but wonder if there was something we could do in a batch file and run every day under the Windows scheduler. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - Delivering the best in health care information and education worldwide. http://www.slackinc.com ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/