User Form to get Hyperlink

  • Thread starter Thread starter jlclyde
  • Start date Start date
J

jlclyde

I am trying to put together a user form that will open windows
explorer and let the person choose a file but not open it. I want it
to record the file name to be ised later on in the work sheet and to
make a link out of it to that location. Is this possible? I have
been playing with the Application.GetOpenFilename, but this is nto
gettign me the address, it is just letting me open a file.

Thanks,
Jay
 
I am trying to put together a user form that will open windows
explorer and let the person choose a file but not open it.  I want it
to record the file name to be ised later on in the work sheet and to
make a link out of it to that location.  Is this possible?  I have
been playing with the Application.GetOpenFilename, but this is nto
gettign me the address, it is just letting me open a file.

Thanks,
Jay
Click to expand...

Never mind!

I answered my own question. GetOpenFilename does get the name and
then I set a cell to be the text. Check it out.
Sub OpenWindowsExplorer()
Dim FileNm As String

FileNm = Application.GetOpenFilename("All files (*.*),*.*")
Range("F1").Hyperlinks.Add Anchor:=Selection, Address:= _
FileNm, TextToDisplay:="Supporting.doc"
End Sub
Sorry,
Jay
 
Back
Top