Hi
I am trying to switch Excel worksheets in VBA. I get an error saying "subscript out of range". Please Help- Here is code (Fails on last 2 lines- Note that I ommited the recordset portion of code because it works):
Dim objXLApp As Object
Dim objXLws As Object
Dim strSDocPath As String 'Full path/name of template (Source) file
Dim strTPath As String 'Full path of (Target)...