application.getopenfilename

Tim


"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