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 |
All times are GMT +1. The time now is 08:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com