igmeou Posted May 13, 2005 Share 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) Link to comment Share on other sites More sharing options...
MarkMarkMark Posted May 13, 2005 Share Posted May 13, 2005 can't you just rename the .xsl to the .csv? Link to comment Share on other sites More sharing options...
MSLx Fanboy Posted May 13, 2005 Share 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()) Link to comment Share on other sites More sharing options...
jdickens Posted May 13, 2005 Share 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. Link to comment Share on other sites More sharing options...
Cyclops Posted May 13, 2005 Share Posted May 13, 2005 or for converting you could use an external freeware like convert-xls Sorry for my cruel english :D Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now