Different path

  • Thread starter Thread starter sunil.s
  • Start date Start date
S

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
 
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
 
Back
Top