Different path

[sunil.s]

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.


Basically i would like to extract the data from the path which is given
as input
Can any one hlep


Thanks
Sam

 

[flummi]

You could try this:

FileName = "\\10.10.10.4\x\y\z\" & InputBox("enter folder name without
backspace") & "\PRODUCTION REPORT.xls"
MsgBox fileName
Workbooks.Open FileName

Hans