VBA code that cut .pdf files and copy in respective folders

So the PDF names would be:

456987.pdf
985423.pdf
3545465.pdf ??

Try this then.... it will highlight the filenames it can't find.

Untested:

Please Login or Register  to view this content.

You read through the macro and corrected the path it is supposed to use to find the files? Once that is edited make sure that sheet with the list of files you uploaded is onscreen, and run the macro.

THe code was tested prior to posting to you. I created 3 files and it moved them accordingly, all the rest were marked in red since I didn't create those.

Well, the macro goes into a standard code module (Insert > Module)

Here's a tiny tweak on the macro to help "create" those folders if they don't exist, also changed the highlight color.

Please Login or Register  to view this content.

Here you can see the macro working: http://screencast.com/t/qAQw2xSKqgiA

I've written a macro, I've recorded a video showing you it is working, and you're getting a very specific error message telling you something is wrong with the path. I've done all I can from my end, you'll have to figure out what's wrong with your path.

Surely you mean this:

Please Login or Register  to view this content.

Notice the quote marks go around the path, not the comment?

The video shows it will move the file if the path is correct and the filenames exactly match a pdf. The path was wrong and you finally fixed that. One must now assume the names of the PDF files are somehow all wrong as well. My videos shows it will color the cells when the files are not found in the path, so it's doing the right thing for files it can't find. Something is amiss with your file names, on the sheet or on the hard drive.

Ok can u send me video . ([email protected])

or Can u elaborate me more on excel sheet number should be 3456567.pdf or simple 3456567
I think i just miss one thing......
Regards

Glad to hear. What turned out to be the problem?

As demonstrated in the video I posted previously, the macro does work, all the problems so far have been examples of things not being in your system as you described. If the text in the cells B1 and C1 are correctly spelled and the text in the cells going down those columns match to real files in that main folder, they will be found and moved. The video proved that. You're going to have to continue to check your system and find the things that aren't right.

From Microsoft:

"Path/File access error (Error 75)

During a file-access or disk-access operation, for example, Open, MkDir, ChDir, or RmDir, the operating system couldn't make a connection between the path and the file name. Possible cause:

The file specification isn't correctly formatted.
A file name can contain a fully qualified (absolute) or relative path. A fully qualified path starts with the drive name (if the path is on another drive) and lists the explicit path from the root to the file. Any path that isn't fully qualified is relative to the current drive and directory."