igmeou 0 Posted May 13, 2005 Hi guys, I have this job nowadays where I need to download some attachment from my email to a specfic folder on my desktop. Then from there I need to unzip a zip file which contains a lot of excel files that is needed to be converted to csv files so that it can be imported into my database. Due to having these lots of files, I thought of writing a script to automate this. The main issue is that I need the excel files to be converted to .CSV files. Please advice. [font="Arial"]Thanks[/font]If @error = me Then $sorry Else Do $clarifyMe Until $meClear EndIF MsgBox(0,"Special Message!","Special Thanks to " & $allHadReplied,$Forever) Share this post Link to post Share on other sites
MarkMarkMark 0 Posted May 13, 2005 can't you just rename the .xsl to the .csv? Share this post Link to post Share on other sites
MSLx Fanboy 0 Posted May 13, 2005 No, its different formats. I would suggest opening each file, one at a time, and just do a File->Save As...There's no easy way to just do file manipulation. Make it easy and let Excel do it for you. Writing AutoIt scripts since _DateAdd("d", -2, _NowCalcDate()) Share this post Link to post Share on other sites
jdickens 1 Posted May 13, 2005 (edited) You can make an Excel macro which runs automatically whenever a file is opened. The conversion can thus be done in Excel macro; all you need to do is send the xls files to Excel. J PS Thanks Cyclops (see below). That's actually what I was looking for to suggest. Edited May 13, 2005 by jdickens If I am too verbose, just say so. You don't need to run on and on. Share this post Link to post Share on other sites
Cyclops 0 Posted May 13, 2005 or for converting you could use an external freeware like convert-xls Sorry for my cruel english :D Share this post Link to post Share on other sites