Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW TO: CONVERT CSV DELIMITED FILES TO XLS
See Chip Pearson's site for code that will read in a CSV file - you can
specify the delimiter: http://www.cpearson.com/excel/imptext.htm import/export text files You can loop through a directory with sName = dir("C:\Myfiles\*.csv") do while sName < "" ' call chips routine to open the file ' save the a file as xls sName = Dir() Loop -- Regards, Tom Ogilvy "BHARATH RAJAMANI" wrote in message ... Can someone guide me how to write a macro that Loops through 'N' .CSV files in a desktop folder and saves them as .XLS files. It is important to recognize the comma delimiter and throw the comma-separated individual values in different cells. If I use a normalExcel fileproperty then my xls file has all values in column A only. TIA Regards, -- Manager, International Private Banking, International Banking Group, ICICI Bank East Wing 8th floor South, ICICI Towers, Bandra Kurla Complex, Mumbai India 400051 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
space delimited files now tab delimited | Excel Discussion (Misc queries) | |||
How can I convert tab delimited files to pipe delimited? | Excel Discussion (Misc queries) | |||
tab delimited file convert to columns | Excel Discussion (Misc queries) | |||
How do I import/convert tab delimited text files into Excel? | Excel Worksheet Functions | |||
tab delimited files | Excel Worksheet Functions |