I have often to open CSV files in Excel (14.0.6112.5000; Office 2010). The data is filled well in the columns, but the DateTime values exceed the default column with and are display as ######. So I have to manually change this width. Further I would like to have to freeze the window at row/colum C2.
Is there a way to do this when opening a CSV automatically or have a script that can be activated by a button?