Inserting a file name

  • Thread starter Thread starter Intruder9
  • Start date Start date
I

Intruder9

I have the following line of code in a macro "FINDER;C:\My
Documents\MR02.IQY", Destination:=Range("A1"))
Is there a way to have a box come up (with the present file in it) and ask
me what file name I would like to find and then have it inserted into the
code so I can chenge it if it was neccesary otherwise it would contain the
present one if I would just like to update it ? The directory would always
be the same, would just like the option to change the file name if needed.
Thanks
 
Where would I find this, searched excel and a book I have on excel and
cannot find these terms, I forgot to mention I have excel97, maybe that is
why?
 
Back
Top