View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dtown Dawg Dtown Dawg is offline
external usenet poster
 
Posts: 22
Default Macro to copy workbooks from one location to another.

I have a folder that contains about 100 workbooks and these workbooks have to
always be there.
What I do now is go to that folder copy all the workbooks and then past them
into a folder on my desktop.

Is there a macro or batch file or something that I can creat that all I have
to do is hit "run" or something and have it go out, copy everythign in that
folder and past it to the folder on my desktop?
Thanks;
The Dawg