View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
JMay JMay is offline
external usenet poster
 
Posts: 468
Default Copy to a flash drive

So can this be done withing Excel VBA - Would you do it differently from
FSt1's code?

"Don Guillett" wrote:

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