Hello all,

I'm still new to VBA, so don't really understand the last post about this.
say that in Sheet1 ( i renamed it to "Input Data") contain data in 2 cell :
Q5 = 08-AUG-2009
Q6 = 30
I want to use this cell to look up a folder name i.e:
"Z:\Shift ProdSouth\COMBINED LOGS 2009\08-AUG-2009\30"
and use the code below, but didn't work. Could you plz help me with this

Sub Test1()

Dim strName As String
Dim strPath1 As String
Dim strPath2 As String

strName = InputData.Range("Q6")
strPath1 = InputData.Range("Q5")
strPath2 = "Z:\Shift ProdSouth\COMBINED LOGS 2009"

Workbooks.Open strPath2 & "\" & strPath1 & "\" & strName

End Sub
Thanks in advance
Miners