Solved

Change links to actual documents (in Windows Explorer)

Posted on 2004-08-19
16
178 Views
Last Modified: 2010-04-13
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
0
Comment
Question by:De_Hond
  • 8
  • 5
16 Comments
 
LVL 9

Expert Comment

by:jdeclue
ID: 11840907
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
 
LVL 1

Author Comment

by:De_Hond
ID: 11841542
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
 
LVL 9

Expert Comment

by:jdeclue
ID: 11841860
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
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
LVL 9

Expert Comment

by:jdeclue
ID: 11841982
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
 
LVL 1

Author Comment

by:De_Hond
ID: 11929139
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
 
LVL 9

Expert Comment

by:jdeclue
ID: 11930113
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
 
LVL 1

Author Comment

by:De_Hond
ID: 11930293
OK. But how do I type
find "V:\" * > results.txt
in the folder with my links?

Arie
0
 
LVL 9

Expert Comment

by:jdeclue
ID: 11930354
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
 
LVL 1

Author Comment

by:De_Hond
ID: 11946198
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
 
LVL 9

Expert Comment

by:jdeclue
ID: 11946257
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
 
LVL 1

Author Comment

by:De_Hond
ID: 11991729
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
 
LVL 9

Accepted Solution

by:
jdeclue earned 500 total points
ID: 11996457
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
 
LVL 9

Expert Comment

by:jdeclue
ID: 12363017
The last answer was extremely detailed and works.

J
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Active Directory Replication 10 1,139
Change port for terminal servers (2000 and 2003) 3 154
how to run this deletion request 4 20
OLD CPUs 12 78
NTFS file system has been developed by Microsoft that is widely used by Windows NT operating system and its advanced versions. It is the mostly used over FAT file system as it provides superior features like reliability, security, storage, efficienc…
Troubleshooting common task sequence error codes
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question