Transfer Text File Name

[kidzmom3]

I have a macro in which I'm using TransferText action to import a tab delimited file. It works great, but I need the File Name to point to a default UNC path that the user(s) set up and store in a table of default settings, i.e. tblDefault, field=NetworkPath.

Any ideas how to get the file name to read the tblDefault.NetworkPath

As always, this bulletin board is a wealth of information and a real life saver!!!!!

 

[namliam]

When using variable setting you cant use a macro you must use VBA.... Try searching in the VBA forum, i bet you will be able to find what your looking for....

Regards

The Mailman

 

[kidzmom3]

The answer is . . . . for future reference. In the File Name area of the TransferText action in the macro, use this.

=DLookUp("[NetworkPath]","tblDefault","[Key]=1")+"file name.txt"

where [NetworkPath]=\\NTSERVER\My Files\

NOTE: Be sure to have the users put the back slash at the end of the path specification.