Excel - Find, Copy files and Paste in new destination

I need help coming up with a macro that you can search for files that
match a certain criteria that may be in various folders/locations, copy
them, and then paste into a new destination.




--
Daniel C

It depends in part upon the criteria. Expand upon "certain criteria" and
you will get a more meaningful answer.

--
I hope you are at least getting some amusement
out of this waste of bandwidth.

The company that I work for has standard drawing files in different
locations.  For instance, there are different folders for Schematic
files, Panel Layout files, Label Files, etc.  The drawings could all
begin with a number like: 278200_.dwg.  I would like to have a macro
built to look up all of the files that meet the criteria of "278200" in
all of the different folders, and then paste them into a new destination
(Project folder).  The parent folder of the project would be something
like: W47100012, and then the subfolders would be:
Cable Diagrams
HMI
Labels
Panel Layout
PLC
Schematics


Auric__;1601183 Wrote:




--
Daniel C

You might want to take a look at a software specifically designed to
manage CAD files named PDMWorks. I use it with SolidWorks but I am sure
it is available as stand-alone.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Thank you.  I will ask someone here who uses Solidworks if they have
that and how it works.  We might still need a macro in Excel, however.


'GS[_2_ Wrote:




--
Daniel C

hi Daniel,

http://www.excelabo.net/trucs/filesearch07

to make the copy file

FileCopy Source, Cible


--
isabelle



Le 2012-04-26 17:06, Daniel C a ?crit :

They're not using that type of system for their SolidWorks drawings

'GS[_2_ Wrote:




--
Daniel C

Thank you Isabelle.

isabelle;1601241 Wrote:




--
Daniel C