Macro which will determine a new scanned file

Hello, I sure can open the developer menu,
but that is pretty much as far as I got :)

OK, so are familiar with library references, because we need to have a reference to the FSO! Can you do that?

no I cannot, I have a very basic and very outdated memories of programming, so please treat like a "new born"

That is the thing. We will spend time custom writing your solution, and it still won't do what you want it to, because you will be able to "port" our solution to your Environment.

Example, Lets say this:

You tell us that the progeram needs to scan the E drive. E drive turns out to be a network drive, but do not have access to the drive. You tell us the program fails, and what really fails is the environment, because your admin hasn't given you rights to the folder. This is only one example why we help with code, but do not design it. We cannot possible write in all of the TRAPS to troubleshoot.

If this is a work thing, you may need to consult the pros, not volunteers for this. We use this at my workplace :https://uplandsoftware.com/filebound/

Thank you so much with such detailed response. However ij alex seeking got a solution exactly for a problem as stated: I will manually scan the file manually place it into corresponding folder, and manually rename it with 6 character name. Need a macro which would create a link in my excel file to every such scanned file and orgonizer them in the rows where 1 row will have files with same names from different folders/directories, and each column will correspond to the foder/directory. Sounds like a very straight forward task.