The first code, I used workbooks.open without () and excel did give me error message. In the second code, I had to use () otherwise I will get error message. Why is that? Thank you so much.
Dim x As String
x = InputBox("enter file name with path")...