see comments within > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Gordon J > Glorfield > Sent: Friday, January 13, 2006 3:59 PM > To: [email protected] > Subject: Re: [U2] making a .csv file into an .xls file? > > > Gordon J. Glorfield > Sr. Applications Developer > MAMSI (A UnitedHealth Company) > 301-360-8839 > > [EMAIL PROTECTED] wrote on 01/13/2006 02:45:46 PM: > > > 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. > > How particular is the 3rd party software? Excel is happy to > load a csv > file that has had it's extension changed from .csv to .xls. > Would that > work for your needs?
I tried changing the extension, and the program bombed out, it is specifically looking for an .xls format, otherwise it fails... :( > > > Is there an easy way to "automate" Excel to load the .csv, > > then save as .xls > > Yes you can. Create a macro in an Excel spreadsheet that does the > conversion. Have the Workbook_Open subroutine run the macro. > Set the > windows scheduler to open the spreadsheet at the desired time > and viola! Problem is I would need UV to create the spreadsheet with the macro.. > > > George ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
