required great HELP.. in converting files

[n.vishwanatha.in]

Hi all,

I am a excel user and I usually get the .csv extension files which
later I have to convert into .xls.


The procedure ren *.csv *.xls is not at all enough. Becos if the .csv
file contains delimeters like , " etc. Hence plz suggest me how to use
the MS-Excel concepts in the DOS.


At present to over come the above problem, I will open the files in
Excel n later give "Save as". hence usinng the delimetered wizards. If
the files are 200 or more it takes too much time to convert.

So please give me Help. Hope you understood the problem ...............

 

[Paul Randall]

Hi all,

I am a excel user and I usually get the .csv extension files which
later I have to convert into .xls.


The procedure ren *.csv *.xls is not at all enough. Becos if the .csv
file contains delimeters like , " etc. Hence plz suggest me how to use
the MS-Excel concepts in the DOS.


At present to over come the above problem, I will open the files in
Excel n later give "Save as". hence usinng the delimetered wizards. If
the files are 200 or more it takes too much time to convert.

So please give me Help. Hope you understood the problem ...............

You can automate the process with Excel's built-in VBA or with a VBScript.
I would try a VBA group, like microsoft.public.excel.programming, and
perhaps crosspost to microsoft.public.scripting.vbscript.

Actually, the answer to you question may have already been posted. Google
is my encyclopedia on all things Microsoft -- try
groups.google.com/advanced_group_search, limit your groups to something like
microsoft.public.*

-Paul Randall

 

[Elmo]

Hi all,

I am a excel user and I usually get the .csv extension files which
later I have to convert into .xls.


The procedure ren *.csv *.xls is not at all enough. Becos if the .csv
file contains delimeters like , " etc. Hence plz suggest me how to use
the MS-Excel concepts in the DOS.


At present to over come the above problem, I will open the files in
Excel n later give "Save as". hence usinng the delimetered wizards. If
the files are 200 or more it takes too much time to convert.

So please give me Help. Hope you understood the problem ...............

here are plenty of discussions of the subject in this Google Groups search.

http://groups.google.com/groups/search?q=dos+convert+csv+to+xls&qt_s=Search+Groups

The first one seems to have an answer.

http://groups.google.com/group/micr...os+convert+csv+to+xls&rnum=1#60932fd316bfb198