is it possible to use both XLS and XLSX types of file in my code.
i am using excel 2010, i have written a macro to get the XLSX types of files as a input to textbox 1 and its working,now how to get both XLSX and XLS,is it possible.
Private Sub CommandButton1_Click()
Dim path1, file_extension, file_name
file_extension = ".xlsx"
file_name = ""
path1 = Browser1(file_extension, file_name)
If path1 <> "" Then Me.TextBox1 = path1
End Sub
Show several types in file dialogbox
Can you show us the contents of your "browser1" procedure ?
Usually there are some ways to use Excel file dialogboxes, specifying the chosen file types.