Sorry the lot is also a feild I brought into the excel file as a check, however, really does not play into what I need.
I will try the delete one also.
My part number are from C4 - C56
Part Number lot number
71219611 256
71219612 266
71219613 288
71219625 299
71219635 310
71219665 333
I want to run the code on the Part number column "C" go find the related document (71219611.pdf example) which is in my Z: drive, once found, copy it to the...
Ok I'm using 2007.
I'm starting with two of the basic code which do work. I'm stuck with the following, How to search for the number in the column to the left? Then what do I change in the code to search for that number in a drive like z:\ and not just a path like I call out below.
Hope this...
Here is my project. I have an excel list of part numbers (PDF forms, the forms are also name after the P/N) which I need to search on my PC's files if found copy or move them to a new location then have an option to later delete them form their old location.
Easy right? Any help would be great...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.