convert CSV to XLS format using command
 

Dave,

That solution is fantastic and does exactly what I had hoped to do without any third party software. Thank you very much!

On Monday, July 21, 2003 7:17:26 PM UTC-5, Dave Peterson wrote:
It looks like you want to use a .vbs (scripting) and Dan wants to use a VBA
macro.

If you really want to use a VBS script, then maybe something like this will get
you started:

Dim myXL
Set myXL = CreateObject("excel.application")

myXL.workbooks.Open "c:\my documents\excel\book1.csv"

myxl.displayalerts = false
myXL.activeworkbook.SaveAs "c:\my documents\excel\book1.xls", -4143
myxl.displayalerts = true

myXL.activeworkbook.Close False

Set myXL = Nothing



copy this to notepad and save it as something.VBS. (and fix the
filenames/location).

But this actually opens excel (hidden, but open), opens the .csv, saves it as
.xls and then closes excel.


kris wrote:

Hi,

I need to convert .CSV file to XLS with out opening excel
2000. I want to do it thru command prompt or vb script.
Can some one help in this regard? any script/ command for
this?

Thanks

--

Dave Peterson