View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jlclyde jlclyde is offline
external usenet poster
 
Posts: 410
Default User Form to get Hyperlink

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