VBA Code to Open CSV and XLS files using Getopenfilename

[suresh ullanki]

Hi,

The following code is not showing to open csv file. Can you please help

FileFilter:="XLS Files (*.xls),*.xls,CSV Files (*.csv),*.csv", _
Title:="Select a file or files", _
MultiSelect:=True)

 

[Domenic]

Actually, if you click on the drop down arrow, you'll see the option to select CSV Files. If you want a single filter for both types of files, try...

FileFilter:="Excel and CSV Files (*.xls;*.csv),*.xls;*.csv"