I am working with CSV files a lot and have to frequently navigate to different directories that contain CSV files. Whenever I press Ctrl + O to open a CSV file, Microsoft Excel 2010 will not list any CSV file because by default it will only show files with the extension *.xls, *.xlsx etc.
I, therefore, have to always configure the file open dialogue box to show the list of all files and then choose the CSV file that I intended to open.
Is there a way that I can figure Microsoft Excel 2010 to show the list of CSV files in the directory and file open dialogue box. If it is difficult to do this by configuring Microsoft Excel 2010, is it possible to achieve this by using a Microsoft Excel macro? Thank you for any inputs