Solved

Change links to actual documents (in Windows Explorer)

Posted on 2004-08-19
16
177 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
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 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Syteline and a new domain controller 4 706
How to NTBackup if SQL Server running? 6 893
Restore SQL database from 8.0 to 11.00 ? 3 1,168
website 1 304
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…
There is no doubt that cloud is gaining importance. Many of you must have read about this technology and its growing importance. More and more organisations are embracing this technology not forgetting start-ups. The process begins by dipping …
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

863 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

27 Experts available now in Live!

Get 1:1 Help Now