I would never save a file to removable media. Save the file and use COPY or
FILECOPY to copy to the flash.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ypukpete" wrote in message
...
i am using Excel 2003. I am looking for VBA code which I can use with a
command button which will open the Copy-to Window so that I can copy the
workbook I have open to a Flash Drive in a USB port. All help gratefully
accepted
Thanks.
--
ypukpete