workbooks.open

[lezawang]

Hi
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.

Sub wb_open_using_collection()
    Dim x As String
    x = InputBox("enter file name with path")
    Workbooks.Open Filename:=x
End Sub

Sub ws_copy_to_closed_wb()
    Dim x As Workbook
    Dim y As String
    y = InputBox("enter file name with path")
    Set x = Workbooks.Open(Filename:=y)
    Workbooks(1).Worksheets(1).Copy after:=x.Worksheets(1)
    
End Sub

 

[Fluff]

You need to put the arguments inside () when you are assigning it to a variable.