If you open the .csv file manually in Excel (via File - Open, running the Text Import Wizard) does the data import correctly? If so, record a macro of you doing those steps and use the Sti string as the file name in the Workbooks.Open code generated by the Macro Recorder (method 2).