Open document in Listbox

[molesy01]

Hi

Hope someone can help with a listbox issue.

I have a listbox with about 10 items. when you click on an item the event (which is coded) will connect to a company database via a hyperlink and will open a document. I have successfully achieved that with vba code and a hyperlink, however, the issue is the document will be replaced with an updated document at times so i presume the hyperlink with change and the link will be unsuccessful, unless i update the hyperlink which would become a tireless chore.

The question is, is there a way of opening the updated document with the file name only.

thanks in anticipation.

 

[Mario_R]

Hello.
If the hyperlink does not work for you, it is because:

- The name of the workbook has been changed, or
- The path of the workbook has been changed.

 

[molesy01]

Hello.
If the hyperlink does not work for you, it is because:

- The name of the workbook has been changed, or
- The path of the workbook has been changed.

Hi Mario

thanks for your reply.

It does work currently but its when the document has been changed and saved again it will have a new hyperlink. I was wondering if i could open the document any other way.

thanks

 

[Mario_R]

You must provide (via a macro or a formula): the new 'Path' or the new 'Workbook Name'.

Do you have that data available?

 

[molesy01]

You must provide (via a macro or a formula): the new 'Path' or the new 'Workbook Name'.

Do you have that data available?

Hi Mario

this is the code that i use. I have a sheet with the document name in A2 and the hyperlink in C2.

Private Sub ListBox1_Change()

Dim strFile As String, f As Range, ws As Worksheet

Set ws = Worksheets("Sheet1")

If ListBox1.Value = "" Then Exit Sub

Set f = ws.Range("A:A").Find(ListBox1.Value, , xlValues, xlWhole)

If Not f Is Nothing Then

ActiveWorkbook.FollowHyperlink Address:=ws.Range("C" & f.Row), NewWindow:=False

End If

End Sub

 

[Mario_R]

You are not understanding: if you changed the name of the workbook or its path then what it shows (which is correct) will not work for you.

You have -necessarily- to redo the Link with the new data.

 

[molesy01]

You are not understanding: if you changed the name of the workbook or its path then what it shows (which is correct) will not work for you.

You have -necessarily- to redo the Link with the new data.

Thank you for your advice.

 

[molesy01]

Hi Mario

Appreciate your advice.

Is it possible to create a userform to change the file name and hyperlink?

If i had a list of documents in cell A1 to A10 and the hyperlink in B1 to B10 is is possible to write code in a text box with the click event via a button.

thanks