Transfert Text File Name

[kidzmom3]

I have a macro that uses the TransferText action to import
at tab delimited file, and it works great, but I want to
have the File Name reference to a field in a table to get
the UNC path. This way the user(s) in each office can
customize the network path for the import without editing
the macro.

 

[Ken Snell]

Use an expression similar to this as the "File Name" argument:

=DLookup("FileNameFieldName", "TableName", "[PKeyField]=" & "SomeValue")

 

[kidzmom3]

Worked like a charm!! Thanks a bunch!!!

-----Original Message-----
Use an expression similar to this as the "File Name" argument:

=DLookup("FileNameFieldName", "TableName", "[PKeyField]=" & "SomeValue")

--
Ken Snell
<MS ACCESS MVP>

I have a macro that uses the TransferText action to import
at tab delimited file, and it works great, but I want to
have the File Name reference to a field in a table to get
the UNC path. This way the user(s) in each office can
customize the network path for the import without editing
the macro.

.