|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
||||
|
||||
|
VB Script help - .xls -> .csv
I am doing this testy little project that will go smooth as silk as soon as I solve this initial little problem. I need to change a bunch of excel spreadsheet (.xls) files to character-separated value text (.csv) files and I want to be lazy and not do them one-by-one (there's about 20 of them.
I was a told by a friend that VB Script can do this, but I don't know how to do it. Can somebody help? Basically, I want to open the Excel file, do a "Save As..." to .csv, then close the file. That's it. Seems simple enough, but these things never turn out that way. Thanks much. |
|
#2
|
||||
|
||||
|
what do you mean when you say that things "never turn out that way"
__________________
Fisherman "Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein |
|
#3
|
||||
|
||||
|
What I meant was that it's the things that look simple that usually wind up giving me fits because I don't know how to do it, or it's there just not obvious, or any one of a number of things.
![]() |
|
#4
|
|||
|
|||
|
I'd probably just open Excel 20 times and use Save As
|
|
#5
|
|||
|
|||
|
If you only have to do it this once, it's probably easier to just open it 20 times and save as *.csv.
If not, record the process of converting the file in a macro for your personal workbook, and add a button to your toolbar with that macro assigned to it. |
![]() |
| Viewing: Dev Shed Forums > Programming Languages - More > Visual Basic Programming > VB Script help - .xls -> .csv |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|