I have been trying to adapt this code to open another workbook (to populate a table) using the entry in "A3" as the filename. Tells me file cannot be found. What am I overlooking. File is in same directory
Sub GetData()
Dim varCellvalue As String
varCellvalue = Range("a3").Value
Workbooks.Open ("p:/My Documents/Driver Database/" & varCellvalue & ".xlsm")
End Sub
Name of actual file required is "14 Driver Assessment wk44"
Any help Appreciated
text content of "A3" is "14 Driver Assessment wk44"
Any help appreciated
Bookmarks