How do I give the user a File Open dialog on transferText macro?

[Q Johnson]

I know I've done this in older versions of Access.

I use ImportDelimited, specify an ImportSpec, specify the target table, and
then type some clever text in the file name text box so that when the macro
runs, a file open dialog will be shown with which the user can hunt the
desired file.

What is that clever text? I remember it beingsomething like
= GetFile()
or the like.

Thanks in advance.

Q Johnson

 

[Douglas J. Steele]

Are you thinking of the code in http://www.mvps.org/access/api/api0001.htm
at "The Access Web"?