Solved

Change links to actual documents (in Windows Explorer)

Posted on 2004-08-19
16
176 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
 
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
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

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…
Are you unable to connect or configure Hotmail email account in Microsoft Outlook 2010, 2007? Or Outlook.com emails are not downloading to Outlook? Lets’ see the problem and resolve Outlook Connector error syncing folder hierarchy (0x8004102A).
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

744 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now