sam,
It seems I'm not the only one confused by what you want.
If you want the user to select a file, then open that file, use
Application.GetOpenname.
(You could use an input box, but why, when you have better alternative.)

If the user has no choice, then why display anything ?

NickHK

"sam" wrote in message
oups.com...
Hi,

I would like to open a file but the path name should be given in the
input box

fox example:


Workbooks.Open Filename:="\\10.10.10.4\x\y\z\a\PRODUCTION REPORT.xls"

here a should be the input message.

Can any one hlep

Thanks
Sam