copy a sheet to a close workbook - vba

[lezawang]

Hi
In the code below, this line of code

Set closedBook = Workbooks.Open("D:\Dropbox\excel\articles\example.xlsm")

Not sure why I need "Set closedBook". Let say I have one Workbook open, which is Workbooks(1). If I do this code

 Workbooks.Open("D:\Dropbox\excel\articles\example.xlsm")

Without "Set closeBook", would that guarantee that the second workbook is going to be Workbooks(2)?

If yes, then why I need to do "Set closedBook"

Another question please, why he did not define

 Dim ClosedBook as Workbook

Sub CopySheetToClosedWB()
Application.ScreenUpdating = False
 
    Set closedBook = Workbooks.Open("D:\Dropbox\excel\articles\example.xlsm")
    Sheets("Sheet1").Copy Before:=closedBook.Sheets(1)
    closedBook.Close SaveChanges:=True
 
Application.ScreenUpdating = True
End Sub

Source: https://www.automateexcel.com/vba/copy-worksheet/

 

[Fluff]

Without "Set closeBook", would that guarantee that the second workbook is going to be Workbooks(2)?

Nope, IMO it's always safer to create & use a variable to refer to other workbooks.

why he did not define

I've no idea, maybe you'd ask him, rather than us.