Open dialog box in vb.net 2005 with all extentions of excel
Posted on 2011-03-16
I have a code to open specific excel extentions.How can I open all extentions of excel.
o.Title = "Select the file to open"
'Excel 2007 Log 8321:
Dim o As New OpenFileDialog()
o.Filter = "Excel Spreadsheets (*.xls)|*.xls|Excel Spreadsheets (*.xlsx)|*.xlsx" ---Need to change here to display all excel extentions
If o.ShowDialog = Windows.Forms.DialogResult.OK Then
If o.FileName <> String.Empty Then
myFiles = Split(o.FileName, vbNullChar)
txtInputFile.Text = (myFiles(0))
Any suggestions appreciated.