This will be useful. Thanks John.
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Reiser, John J Sent: Thursday, January 19, 2012 10:37 AM To: arslist@ARSLIST.ORG Subject: Re: Replacement of CSV reports ** Joseph, I had found a VB Script awhile ago that will convert an xls file to csv. It even handles the multiple sheets by creating a csv file for each sheet. I forget where I got it and the author didn't put anything in the script to identify him/her. Hope I'm not violating SOPA. Dim oFSO Dim oShell, oExcel, oFile, oSheet Set oFSO = CreateObject("Scripting.FileSystemObject") Set oShell = CreateObject("WScript.Shell") Set oExcel = CreateObject("Excel.Application") oExcel.DisplayAlerts = False For Each oFile In oFSO.GetFolder("C:\BMC ARSystem\Projects\xls_files\").Files If LCase(oFSO.GetExtensionName(oFile)) = "xls" Then With oExcel.Workbooks.Open(oFile, 0, True, , , , True, , , , False, , False) For Each oSheet In .Worksheets oSheet.SaveAs "C:\BMC ARSystem\Projects\csv_files\" & oFile.Name & "." & oSheet.Name &".csv", 6 Next .Close False, , False End With End If Next oExcel.Quit oShell.Popup "Conversion complete", 10 To Whom it may concern, If you recognize this as your own work please take credit for it. Thanks --- John J. Reiser Remedy Developer/Administrator Senior Software Development Analyst Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Butera, Joseph Sent: Thursday, January 19, 2012 10:10 AM To: arslist@ARSLIST.ORG Subject: EXTERNAL: Re: Replacement of CSV reports ** Is there any way to remove the pagination of the excel files? The data is written to multiple worksheets. Much easier if written to just one by default. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Easter, David Sent: Thursday, January 19, 2012 10:03 AM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: Replacement of CSV reports ** >From the documentation: [cid:image001.png@01CCD6A5.53AF3140] -David J. Easter Manager of Product Management, Remedy Platform BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mahmoud Mahdy-Mohamed Sent: Thursday, January 19, 2012 1:47 AM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Replacement of CSV reports ** Dears, We are upgrading from 7.1.0 to 7.6.4 SP2 and we want a replacement tool for extracting users reports on CSV files(excel sheet)as ver 7.6.4 sp2 doesn't have any "Export to" option like in the previous version. Please advice. Thanks, Best Regards, Mahmoud Mahdy Mohammed,PMP | Business Process Automation Technology | Products & Services Delivery Phone: +20(0)104999638 Mail: mahmoud.mahdy-moha...@vodafone.com<mailto:mohamed.abdel-haf...@vodafone.com> ************************************************************************************************************************* The content of this document is classified as Vodafone Egypt S.A.E. Confidential and Proprietary Information. The recipient hereby is committed to hold in strict confidence the contents of this (e-mail, document, information) and not to disclose to any third party without the prior written consent of Vodafone Egypt S.A.E. Recipient will be held liable for any unauthorized disclosure. If you have received this message in error, please notify the sender by return e-mail and delete the message in its entirety, including any attachments. http://www.vodafone.com.eg<http://www.vodafone.com.eg/> ************************************************************************************************************************* _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
<<inline: image001.png>>
