I have to take an excel SS created by another application and turn it into a .csv file. The task has to be automated. What I think I would like to do is create a batch file that I can execute via the MS Task scheduler that will automatically open the file in Excel and then save it as a csv. Is it possible to automate that process somehow?
See if this helps: http://www.utteraccess.com/wiki/Schedule_a_Macro_to_Run.
It is a two-step process:
-You fill out a script file and tell it the path and name to the spreadsheet you want to run and the macro in that spreadsheet to run.
-The script creates the "program string" that you can copy and paste into the task scheduler.
-The task scheduler opens the script that has an on open macro that opens the target workbook and executes the macro in it.
It sounds like in your case you need a spreadsheet to find the other spreadsheet, open it and save it as a CSV file.
I'd need to know a little bit more about how things are set up. If the program is going to work, it will need to know the name of the file to open. Is the name "predictable," that is, does the file have the same name every day perhaps with a date stamp?
I am assuming that there is some reason why you want to use the task scheduler for this such as running it so the CSV file will be in place for some other program. I don't think it should take more than a couple of seconds to convert the file.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
To answer your questions:
Yes it'll have the same name.
This is a monthly process. I'm semi-constrained in the software I have to use, IOW it has to be stuff we
already have. Our IT Security folks are rather firm on that.
I'm going to use a package called MARS by Christian Steven software to create the Excel file in a known directory with a known name at a
known time. There's a package further on down the line that requires a csv file for import. I'm hoping to use Excel in the middle to
convert the Excel file to a csv.
This all has to be automated which is why I was hoping to use the Task Scheduler to run a .bat file that will automate the import
of the Excel file and then export a .csv file. It's as simple as opening the excel file and saving it as a .csv.
....at least that's what I came up with. I know its a kludge but logically it should work.
Here is how you should set it up.
In the attached, change the path name and file name on Sheet1 to fit your situation. This will be the path and name where the Excel file will be placed.
Save this file in a convenient place.
Then use the script program in the link in my previous post.
Use the path to where you save this file (it may or not be the same place as the downloaded excel file) as the first line in the script.
Use this file name (XL2CSV.xlsb) in the second line in the scrip
Use the macro name (ExcelToCSV) in the third line of the script.
Copy the value in row 11 to notepad.
Open the task scheduler, when it comes to the point where you run a program, copy in the value you saved to notepad. The task scheduler will pick up that this is an executable with an argument, so click OK.
Complete filling out the task scheduler.
In this case, it's a three-legged race: the task scheduler runs the script, the script runs this program, this program opens the target excel file and saves it as CSV.
You should not have to change anything in the programming; it's all "fill in the blanks."
To save you from downloading from the link, here is the script file change the name to something descriptive before opening it and filling it in.
Awesome, ty - I'll give it a shot tomorrow when I'm at work.
This is interesting and relates to a project I need to complete. I am wondering will this process work in reverse? Can a csv file be saved as an excel file each time a csv file is created (saved in Directory (x) as it were.?Originally Posted by dflak
Administrative Note:
Hello Tomo453 and Welcome to Excel Forum.
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.
Please see Forum Rule #4 about hijacking and start a new thread for your query.
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks