I have a table with fixed length fields that is linked to an external text file. I want the operator to be able to select a different file and replace the connection name to the selected file name. For example, the table is currently linked to a file named C:\Temp\January.txt. I want the operator to be able to designate the file C:\Temp\March.txt and then I want to re-link the table to the new file name using VBA.