Pietersen
11-12-2010, 04:32 AM
Hello,
I've got an excel code to create hyperlinks for all excel files in a certain folder and list them in column A.
The name of the hyperlinks is the same as the file name in the folder.
Now the filenames are all coded like "516800.4,1.filename"
"516800.4,2.filename"
Now i'm looking for a way to match and paste these hyperlinks automaticly to another sheet in my workbook.
In the other sheet i have a row that need to get matched to the first 6 numbers, like 516800, 516810 etc.
And the 2nd part of the filename needs to be matched with the first column in the same sheet.
Is this at all possible? If so, any help would be greatly appreciated.
I've got an excel code to create hyperlinks for all excel files in a certain folder and list them in column A.
The name of the hyperlinks is the same as the file name in the folder.
Now the filenames are all coded like "516800.4,1.filename"
"516800.4,2.filename"
Now i'm looking for a way to match and paste these hyperlinks automaticly to another sheet in my workbook.
In the other sheet i have a row that need to get matched to the first 6 numbers, like 516800, 516810 etc.
And the 2nd part of the filename needs to be matched with the first column in the same sheet.
Is this at all possible? If so, any help would be greatly appreciated.