I think Accuterm can create a legit .xls file on a windows client with the FT utility. This is easily scripted from the UV side.
/Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Friday, January 13, 2006 11:46 AM To: u2-users@listserver.u2ug.org Subject: [U2] making a .csv file into an .xls file? 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/
