Dear All,

i have assigned a file name in a cell as mentioned below:

Cell Range File Name
AW17 Report1.xls


Thro' VBA code i am calling the file name as said below:

filename = Cells(17, 49).Value
Set TargetWB = Workbooks.Open(tPath & Application.PathSeparator & "filename")

But it is not working. Please tell me the right method for calling the file name.