Change links to actual documents (in Windows Explorer)

Some users here have an extensive collection of quick links in Windows Explorer. Now they want to convert these links to the actual documents that the links refer to. Does somebody know how to do this automatically (e.g. using VBA)?

Thanks, Arie
LVL 1
De_HondAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
jdeclueConnect With a Mentor Commented:
I will explain exactly how it works for me. This is for a folder called "links" on my mapped drive Z. I copied links into this folder. All of my links are point to files on the C: drive

Open "CMD" - Open Command Prompt
Type "Z:" - Go to "Z:"
Type "cd links" - Change directory to links folder
Type "find "C:\" * > results.txt" - create file called "results.txt" and put in all line with a "C:\" in them.
Type "find "C:\" results.txt > paths.txt" - NEW STEP - create one file with all of the results - Nice and Neat.

Now the file "paths.txt" will only have one line at the top with the "--------- Shortcut to", in it. Just delete the line at the top before you do the search and replace to create the batch file.

J

Contents of "results.txt"

---------- RESULTS.TXT

---------- SHORTCUT TO DCDIAG_SETUP.EXE.LNK
C:\Documents and Settings\jmd\Desktop\dcdiag_setup.exe

---------- SHORTCUT TO IE6SETUP.EXE.LNK
C:\Documents and Settings\jmd\Desktop\ie6setup.exe

---------- SHORTCUT TO MICROSOFT DOWNLOADS.LNK
C:\Documents and Settings\jmd\Desktop\Microsoft Downloads

---------- SHORTCUT TO SECTEMPLATES.MSC.LNK
C:\Documents and Settings\jmd\Desktop\SecTemplates.msc



Contents of "Path.txt"

---------- RESULTS.TXT
C:\Documents and Settings\jmd\Desktop\dcdiag_setup.exe
C:\Documents and Settings\jmd\Desktop\ie6setup.exe
C:\Documents and Settings\jmd\Desktop\Microsoft Downloads
C:\Documents and Settings\jmd\Desktop\SecTemplates.msc


0
 
jdeclueCommented:
Can you try to explain this one in more detail. The quicklinks are shortcuts to documents, but what do you mean by "convert these links to the actual documents"? Are you looking to copy the files to their machines? Create shutcuts on the Desktop or elsewhere? Etc.

J
0
 
De_HondAuthor Commented:
Hoi J,

The collection of quicklinks (e.g. in map t:\links) are indeed shortcuts to documents. What I need is an automated way to pull all the documents (e.g. in map v:\docs and v:\docs2) that the shortcuts refer to, into one map (e.g. t:\links). After that the shortcuts can be deleted.

After that I am able to upload the newly created collection of documents to a sharepoint server.

Arie
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
jdeclueCommented:
Ok, I see what you are doing. You are using a folder as a "library" by creating links to documents that are located in different places. Now you want a folder with all of those documents in it, so you can upload them all, into a Sharepoint Document Library. Right?

J
0
 
jdeclueCommented:
Do all of the shortcuts point to one mapped drive letter, like  "V:\*"?

If they do, then go into the links folder and type this.

find "V:\" * > results.txt

Then open results.txt in notepad.

Let me know if this works to get a list of all the documents with their full paths.

J
0
 
De_HondAuthor Commented:
Sorry for the delay.

The above solution doesn't work for me. I need the actual documents pulled into the map t:\links
I do not need a list of documents with their full path.

Arie
0
 
jdeclueCommented:
That was only part of the answer, After you do the find, you will have a list of all the files in a text file. Next step.

Open the text file

Each of the lines start with the same thing. So if it start with v:\ got to "Edit" and do a search and replace.
Set the search term to "V:\"
Set the replace to "copy V:\"
Click on replace all.
rename the results.txt > results.bat
Copy the file into the folder, you want all of the files in, and the run results.bat.

The whole process, hopefully makes it alot easier than trying to find them all... ;)

J
0
 
De_HondAuthor Commented:
OK. But how do I type
find "V:\" * > results.txt
in the folder with my links?

Arie
0
 
jdeclueCommented:
Yes, when you type:

find "V:\" * > results.txt

In the folder with all of the links, it will open up each one of them and find the path and name of the file, if it starts with "v:\", and put a file in that folder called results.txt.

Try it out, and then open results.txt in notepad. Let me know if the file looks right.

J
0
 
De_HondAuthor Commented:
We seem to be in Babelonia...

WHERE do I type find "V:\" * > results.txt ????????

The only place I can type things in the address bar in Windows Explorer, but that doesn't work.

Arie
0
 
jdeclueCommented:
You must do it from a command prompt.

Start | Run | "cmd" <--Enter

then Change directories to the network drive and type the command in the folder where the links are.

J
0
 
De_HondAuthor Commented:
Hi J,

This doesn't work. My results file contains lines like:
---------- SHORTCUT TO VT2004.MLD.LNK

It seems it gives back the files in the links folder and that is not the idea....

Other ideas?
0
 
jdeclueCommented:
The last answer was extremely detailed and works.

J
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.