Have you tried =Getfile() ?

For example:

=getfile('CSV', 'Filename:', 'Browse', 1, 'Select filename')