I have the following:

lcCmd=[Copy To ]+thisform.exportfilename1+[ DELIMITED]
&lcCmd

Where thisform.exportfilename1="C:\Documents and Settings\kirk\My Documents\0001_NHSN_JUL07.CSV DELIMITED"

and lcCmd ends up being:

"Copy To C:\Documents and Settings\kirk\My Documents\0001_NHSN_JUL07.CSV DELIMITED"

When the code runs I get the following error:
"Command contains unrecognized phrase/keyword."

But I think is is because of the long file name with the spaces. If I just change it to c:\0001_NHSN_JUL07.CSV
it all works.

Thanks

Kirk