Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW TO: CONVERT CSV DELIMITED FILES TO XLS
Tom, the CELLS (..) statement in Pearson's code writes to the file that
contains the macro. Stephen Wortley suggested another elegant solution with the Workbooks.OpenText property. It works well, in cohesion with your code. Thanks for all the help to you and Stephen !! Regards, "BHARATH RAJAMANI" wrote: 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 |
Reply |
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) | |||
How do I import/convert tab delimited text files into Excel? | Excel Worksheet Functions | |||
HOW TO: CONVERT CSV DELIMITED FILES TO XLS | Excel Programming | |||
HOW TO: CONVERT CSV DELIMITED FILES TO XLS | Excel Programming |