Prompting user for path and file

[rmiller]

I have used the folowing statement in Excel VBA

path = Application.GetOpenFilename("Text Files (*.txt), *.txt,,<prompt>)

to display the file opoen screen for the user to browse and select a file that is returned to the variable path.

Question:

Is there an equivalent Access VBA function?

I am trying to read and parse a text file that is sent to me daily and extract information that I will place in an Access table.

 

[ghudson]

Welcome to the forum.

The Search function on this forum really does work and members are encouraged to use it before posting.

Browse [Find a directory or file]

 

[rmiller]

Browse file open

Thanks for the information. Sorry I did not check first, it was my very first post.

Rmiller

 

[ghudson]

That is why I "welcomed" you to the forum.