Change the extension to .txt instead of .csv and then open it in excel.  Walk
through the text import wizard with the macro recorder turn on.  

In the last dialog indicate which columns should be treated as text.

complete the import and turn off the macro recorder.

In your code, add code at the top to copy the file and rename the copy with
a .txt extension.  Then open that (and delete it later if necessary).

Even with recorded code, it you open a file with a .csv extention, your
settings will be ignored.