Excel - Find, Copy files and Paste in new destination
Asked By Daniel C on 25-Apr-12 11:44 AM
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.
Auric__ replied to Daniel C on 25-Apr-12 10:20 PM
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.
Daniel C replied to Auric__ on 26-Apr-12 08:26 AM
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:
GS replied to Daniel C on 26-Apr-12 12:16 PM
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.
Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
Daniel C replied to GS on 26-Apr-12 05:06 PM
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.
isabelle replied to Daniel C on 27-Apr-12 02:17 PM
to make the copy file
FileCopy Source, Cible
Le 2012-04-26 17:06, Daniel C a ?crit :
Daniel C replied to GS on 27-Apr-12 11:53 AM
They're not using that type of system for their SolidWorks drawings
Daniel C replied to isabelle on 01-May-12 07:59 AM
Thank you Isabelle.