Hi
try recording a macro while doing this manually

--
Regards
Frank Kabel
Frankfurt, Germany

"CB" <cblairATfargo.com schrieb im Newsbeitrag
...
I am using a db qry in excel to populate 2 columns of data. I then
use a
concatenate function to combine that column with a copy command to
get a
usable statement (copy file location). Is there a way after a data
refresh
to automatically export the concatenated column into a bat file?