Open a workbook from a written path
Hi Don,
It worked for me for Excel 2000 using
Sub openfile()
Workbooks.Open ThisWorkbook.Worksheets("Sheet1").Range("a3").Text
End Sub
Did you change the range to match "A20"?
If so, it sounds like your path is not complete, to me.
Dan
|