File name on form read by module 1

[omooreirl]

Hi all

I have a module written to import a text file into my access database. The name of the text file will change about every 3 days or so and is not predictable. I need the user to enter the name of the new file on my form such that my module can then read the name and open it.

Can anyone point me in the direction of the best way to do this? I don't need to store the name of the file.

Thanks
OM

 

[PHV]

You may simply use the InputBox function in your VBA code.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[omooreirl]

Perfect.

Thank you.

OM