How to select a file via VBA?

[hanski]

hi.

I have a command in VBA:

"DoCmd.TransferText acImportDelim, "ImportRules", "Sheet1", "c:
\SavedFiles\importfile.csv", True

Problem is:

I do not always want import file c:\SavedFiles\importfile.csv.
Sometimes it is a different name of file in the same directory for
instance c:\SavedFiles\importfile_2.csv

Can I somehow browse, or something like that, the new file?

hanski

 

[Allen Browne]

Use this API call to get the Windows FileOpen dialog
http://www.mvps.org/access/api/api0001.htm