From: Wayne Brissette <wbrisett@...>
Date: 2011-12-28T20:15:30+09:00
Subject: Re: Simple CSV and Excel problem.


On Dec 28, 2011, at 3:40 AM, Vimal Selvam wrote:

> Hi Cristian,
> 
> Importing into excel, then looping into every cell or range is a time
> consuming process. Instead, you rename the file from csv to xls and use
> the WIN32OLE built-in method called: 'TextToColumns'.

I must be missing something, why not leave it as a .csv file? These are readily opened by Excel to start with, why go through the trouble of converting them to native .xls files? I'm sure I'm missing something, which is why I've asked.

Wayne