View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Shunt Shunt is offline
external usenet poster
 
Posts: 14
Default Specify file location

Is there a way of specifying a file (or multiple files) by
a graphical form method and then storing the pathname in a
cell or userform field?

For example if i wanted to specify c:\hello.xls I could
click on a button which would bring up a GUI form (klike
explorer) which i could browse through and select my file.
Upon pressing OK the pathname would be transferred to a
cell.

I can't think of anyway this would be possible so any
solutions would be much appreciated.

Nick