Compile error "Subscript out of range" in simple set statement

[ibud00]

I'm obviously missing a fundamental concept. I have reduced my problem down to a few lines of code, and still can't solve it.

Sub tstSbScrptRng()


    Dim wkBk As Workbook
    Dim sPath As String
    Dim sFile As String
    
    sPath = "C:\Users\ibud0\Documents\"
    sFile = "Garbage.xlsx"
    
    Set wkBk = Workbooks(sPath & sFile)
'   Last statement gets "Subscript out of range" compile error message
    
End Sub

I'm drowning - please help!

 

[RoryA]

If the workbook is open, you should be using:

Set wkBk = Workbooks(sFile)

If not, you need to open it:

Set wkBk = Workbooks.Open(sPath & sFile)

 

[wideboydixon]

If the workbook isn't already open then you need:

Set wkBk = Workbooks.Open(sPath & sFile)

If the workbook is already open then you need:

Set wkBk = Workbooks(sFile)

WBD

 

[wideboydixon]

*woof* *woof*

 

[RoryA]