How do I open CSV using Excel without deleting leading zeros?

Thanks. But the thing is I don't want to change the CSV file before I open it. I have a loop that populate each cell one by one from the CSV file. But it is not effecient.

Thank you for the help.

I did that on my current appraoch. I set all cells to Text and populate the cell one by one. So, it is pretty slow compare to Excel default file loader. Excel open up a CSV file in one second. Mine takes a long time depends on number of cells I am populating. I think 10K cells takes about 5 seconds, pretty slow. I am going to twick it a bit to load 5 times faster. But I think my way is no where near as fast as the Excel CSV loader though. Oh well, I guess I just have to live with that.

Thank you very much. That sounds like a good idea because it skips the screen refresh slowness. Maybe I can create a Range object and then swap that with Cells. That will be so fast.

One way to divine the inner workings of any office document and how to manage it via the interops is to record a macro of the process needed. Once done examine the vba code, it will show settings changes and other items of interest that can lead the way through the tribal knowledge of the interops.

If no one has an answer...try posting it in the Discussions in Office Development or for a better responses or Discussions in Automation forum for interop questions.