UDF Choose csv file from dialog box

This UDF opens up the dialog box to choose a file to import into an Excel woorkbook.


Function GetFile() As String
Dim filename__path As Variant
filename__path = Application.GetOpenFilename(FileFilter:="Csv (*.CSV), *.CSV", Title:="Select File To Be Opened")
If filename__path = False Then Exit Function
GetFile = filename__path
End Function






Contact us for some advice and guidance on how your Excel development could be created and start helping your business straight away. Contact Us

Datanology