I recently looked into auto formatting text files ready for EXCEL, e.g., take a CSV file and change it to xls and at the same time format the columns widths etc. I know it can be done other ways, xml etc, but this way we could convert all out current reports without changing any code.
There where a few utilities that could do this, they also convert from CSV to xls by simply calling the utility and specifying the name. Here is just one example, not the one I tested. http://www.softinterface.com/Convert-XLS/Convert-XLS.htm If you look for other software it must be able to do the business from the command prompt so it can be automated into you code. Create the report, issue the command and there you go, one xl file ready to use. Re andy -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: 13 January 2006 20:46 To: [email protected] 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 [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
