Unable to detect CSV file.

[JapanDave]

I have some code that prompts you to select a file to extract data from, but when I open the folder with the CSV files it is empty, but if I have a normal ".xls" file it detects it fine. The code worked on my previous PC which was Vista, butI just upgraded my PC to Windows 7 and Office 2010. Could this be the cause, or is the code not working the way it should?

Please Login or Register  to view this content.

[tigeravatar]

If you want the GetOpenFileName to be able to view .csv files, then you need to change the FileFilter property. To view only .csv files, you would use:

Please Login or Register  to view this content.

To view only .csv and .xls* files you would use:

Please Login or Register  to view this content.

To view all files, don't have a FileFilter property:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

[JapanDave]

Hey Tiger,
It is actually your code.

I tried to change the code without success obviously. Is there a reason why the CSV files don't have an asterix at the end only at the start , but the ".xls" files have the asterix at both the start and the end in the code?

Please Login or Register  to view this content.

[tigeravatar]

JapanDave,

The reason is that Excel files come in more formats than just .xls. For example, they can be .xlsx or .xlsm. If you only searched for *.xls, you would miss those other kinds of Excel files. The .csv files on the other hand are only .csv with no variation, so there's no need to search for different kinds of extensions.

~tigeravatar

[JapanDave]

Thanks , that really helps a lot.