Creating more than one Hyperlink at a time.

  1936 20:48 30 Nov 09
Locked

I have a large number of text files that I scanned into different folders such as, essays, newspaper articles etc.
I saved the files by name followed by the date I wrote them. It was only when I tried to add an extra field to the file name so that I could sort them by name or the date written that I discovered it was not possible because I have never needed to do this exercise before.
I know that I could copy the folder and then change the file titles from starting with their name to starting with the date that they were written but that would mean doubling up a number of very large folders and I don’t want to do that.
Then a kind person told me that I could do what I wanted if I used Excel and the Hyperlink process which is great even though there is a bit of cutting and pasting to do.
There is one problem and that is that I have to go through the following process for every file:
1. Right click and open Hyperlink.
2. Click onto “My Documents to find the folder.
3. Click onto the folder to bring the files up.
4. Click onto OK and the file name comes up on Excel and I cut and paste the different fields that I want to sort by.

Now, that all very well as far as it goes but I have to go through the whole process for each separate file and the question is:
Is it possible to effect the creation of a number Hyperlinks at the same time to save having to go through that laborious process?

  bremner 11:27 01 Dec 09

A quick Google found this click here

This thread is now locked and can not be replied to.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Method Studios' title sequence for BBC series Taboo is truly unsettling

Best Pages for iOS tips | How to use Pages for iPad & iPhone: 6 simple tips to get more out of…