Import Macro

[fh721]

Hi,

I am using the TransferText Action in a macro, is there any way to code
in the filename parameter to look for the file in the folder where the
database resides? My users will make a copy of this database (empty) and
import the file and I would like to tell them to put the file to be imported
into the same folder where they copied the database without having to prompt
them for the path. Thank you.

 

[Steve Schapel]

Fh721,

=[CurrentProject].[Path] & "\YourFile.txt"

 

[fh721]

Hi Steve

Thank you, exactly what I needed.

Thanks again

Bob