I'd like to set Excel 2010 to open the import wizard each time I double click on a CSV file rather than have Excel open the file without the wizard. Previous versions of Excel did this but 2010 immediately opens the file. I deal with CSV files that use different delimeters (pipe, semicolon, etc) so when Excel opens the file without the wizard, I often have to click on a cell and manually open the import wizard. It would be more efficient to simply open the wizard each time.
OpenOffice does this but most of the time I need to export these to an Excel file so using OO isn't really an option. Is there a way to force Excel 2010 to open the wizard each time I open a CSV file? I've read some of the other guides here on SE but those still aim at opening the CSV directly in Excel without using the wizard which isn't what I need.
