"Dave Peterson" wrote
You can have a macro that in the first workbook that opens the .CSV file
and
then closes itself:

Thanks for the response but what you suggest doesn't fit the bill.
I won't have access to the workbook once it's distributed and I want to keep
changing the destination file.