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? > 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! > > 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. Excel has that capture keystrokes in a macro capability built right in. > George [snip] This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
