Andy, There is a thread from Nov 19 entitled "Export Form Data to Excel on Button Action" that may help.
Stephen Remedy Skilled Professional -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Thursday, January 10, 2008 12:39 PM To: [email protected] Subject: CSV TO XLS via OLE Has anyone out there ever tried to utilize OLE to convert .csv files to .xls files? I've been trying to use the example on Gidd's website, but I think I have something wrong. I can get it to convert the .csv file to an .xls file, but it basically seems to be putting all the data in a single cell with the data being separated by a comma. I would have expected it to display the data as it would have the original .csv file, with all the data separated into the rows and columns. Does anyone have any pointers for me on this? I'm open to any suggestions. I just need to be able to have Remedy generate a report and save it in the .xls format. I really don't care about the field formatting or anything like that. Just has to be an .xls file. Thanks, Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
