S
Shunt
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
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