Put a file's name and date stamp into a string?

[dkaplan]

Is it possible to capture a file’s name and date stamp into a string? Ideally this file would be selected from a form through a file | open dialog box. (The file in question would be a text file, which would later be parsed using VBA.)

Thanks.

Dennis

 

[tomschafer]

If you have the full name of the file you can pass it into the filedatetime function to get the datetime stamp. i.e.

filedatetime("c:\somedirectory\filename.txt&quot

 

[dkaplan]

First off, let me thank you for responding to two of my questions in one day.

As for the above, I'm realizing that I should have been more specific about what I am trying to do. Esentially, I'm trying to let the user import a text file without having to go through the Access interface. Once I have the file name, my code can do the rest. But rather than make the user type in the file name, I'd like to let him/her select it with something like a standard Windows dialog box?

Possible?

Thanks again,

Dennis