Matching imported hyperlinks to another cell

[Pietersen]

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.

[mdmackillop]

Welcome to VBAX
Can you post a sample showing your layout and some data? Use Manage Attachments in the Go Advanced reply section

[Tovarocks]

Hello, I was trying to do something like this, I've found this post but without solution, somebody can help with this?, here is an example of what I want to do, I just need to check if the code in the pivottable and folder exist, then create an hyperlink.

I got this code but it makes hyperlink to all files from the folder and I need the "MATCH".


Sub Hiper1() ChDir (ActiveWorkbook.Path)
arch = Dir("C:\*.jpg")
fil = 1
Do Until arch = ""
Range("R" & fil).Offset(2, 0) = arch
Range("R" & fil).Offset(2, 0).Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:=arch, _
TextToDisplay:=arch
fil = fil + 1
arch = Dir
Loop
End Sub

[Tovarocks]

Somebody can help me with this? please!

[Tovarocks]

Somebody can help me with this? please! I need it!