Redirecting
You could have the macro reads a text file to get the name and then open that
file.
tishoo wrote:
"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.
--
Dave Peterson
|