Inserting a file name

[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

 

[Orlando Magalhães Filho]

Hi,

See GetOpenFilename or GetSaveFilename Methods.

HTH

 

[Intruder9]

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?