Have you looked at GetOpenFilename in VBA Help?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JohnnyJomp" wrote in message
...
Hi all...
I would like to record a macro that will pause while I browse to locate a
spreadsheet.
I need to perform the same functions on many spreadsheets that have
different names, so I would like to start the macro, have it do a function
or
two, then pause while browse or type in a file name, then continue with
the
rest of the functions.

Any ideas?
Thanks!
John