Find, Copy files and Paste in new destination

[Daniel C]

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

 

[Auric__]

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.

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

 

[Daniel C]

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

 

[GS]

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'm sure
it's 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

 

[Daniel C]

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

;1601209']You might want to take a look at a software specificall
designed to
manage CAD files named PDMWorks. I use it with SolidWorks but I'm sure
it's 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.discussio

 

[Daniel C]

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

;1601209']You might want to take a look at a software specificall
designed to
manage CAD files named PDMWorks. I use it with SolidWorks but I'm sure
it's 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.discussio

 

[isabelle]

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 :

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.

;1601209']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'm sure
it's 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

 

[Daniel C]

Thank you Isabelle.

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 :-

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:-

;1601209']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' sure
it's 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-