Doug,

Take a look at GetOpenFileName method in help. This will give a browser
dialog. You then have to open the chosen file, and you will be able tyo
access the Activeworkbook Activesheet to get your data.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"doug" wrote in message
...


is there a way to have a macro prompt the user to specify
a file to be openedn and then grab data and formulas from
that sheet and bring it into a new project.
thanks
doug