Thanks dave for the help with the error . I have 2 things left that i needed
it to do and ill be all done.

1. how do i make the right work book active? I have tried doing it as a
copy/paste and as this query way but it goes to the work sheet that is being
opened not the one that was open.
2. How do I Close the cvs file after import? Should i just use a .close
statment?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200611/1