I have an entry form to insert data to insert at the next empty row
There is also a button 'Link To'. When I click it, it opens a brows
file pop up box for the user to select a file to link to. That is a
far as I got.
What I am using for the Link To button is
Private Sub cmdLinkTo_Click()
Application.Dialogs(xlDialogInsertHyperlink).Show
End Sub
What I am having a problem with is I would like the path of the file t
appear in the 'txtHyperlinkAddress' box. There is a 'txtFileName' wher
the user would type in the name of the linked file as how he wants i
to appear in the active row and cell in the data sheet.
And the problem is how to proceed from here. I appreciate any help.
ryss
--
Message posted from
http://www.ExcelForum.com