?
Solved

Change links to actual documents (in Windows Explorer)

Posted on 2004-08-19
16
Medium Priority
?
185 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
13 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
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
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 2000 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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…
Over time, the online landscape has altered considerably, but that’s nothing compared to the up-and-coming trends that will shape the web design industry in the coming year. Keep reading to find out which trends will shape B2B web design in 2018.
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses
Course of the Month13 days, 21 hours left to enroll

809 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