Open Workbook from cell value

**miners** · 08-31-2009, 10:19 PM

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

Please Login or Register  to view this content.

Thanks in advance
Miners

**Leith Ross** · 08-31-2009, 10:30 PM

Hello miners,

The Workbook.Open statement requires the name of the workbook to open, like "Reports.xls". If the path isn't supplied, the current directory is used. You supplied the path but not the workbook name.