> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Dave S > Sent: Friday, January 13, 2006 4:56 PM > To: [email protected] > Subject: Re: [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. > > 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?
It's VERY particular. > > > 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! not sure if I can do this with a macro, as the file is not created on the windows machine, but rather on the unix side. As well, there is the possiblity that for security reasons, some of the PC's used to load this file, may possibly have macros disabled. And to start have very non-savvy people to override that feature could be very dangerous to our network. > George ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
