Take a look at application.getopenfilename in VBA's help

Chip Smith wrote:

is there a way to use a macro to open a file. i know you can use the findfile
function. but what i am looking for is for when the macro runs it opens a
browse box that prompts the user to find their file to open. then it opens
the file. any suggestions?

--
--Chip Smith--
MVP Wannabe :)

--

Dave Peterson