vba error when copy/paste without clipboard

[DDT~123]

Hello all - I'm receiving a "missing object" error in the below code. This is only a smidgen of much a much larger code which copies 100 text files into 100 worksheets. The range in File2 may vary, but will never be larger than A1:R55. Any assistance in having this copy/paste without clipboard would be greatly appreciated.

Public Sub ImportCMS()
Dim File1, File2 As String
File1 = ActiveWorkbook.Name
ws = ActiveSheet.Name

With Sheets("account1")
.Range(.Cells(10, 1), .Cells(64, 18)).ClearContents
End With
File2 = "C:\Users\dturner\Desktop\ServiceLevelsSMS\IntervalScriptOutput\account1.txt"
Workbooks.Open File2
wFile = ActiveWorkbook.Name
With Range("A1:R55")
    Windows(File1).Sheets(ws).Range("A10").Resize(.Rows.Count, .Columns.Count).Value = .Value
End With
Application.CutCopyMode = False
Workbooks(wFile).Close False
If ActiveSheet.Name = "Sheet1" Then
Application.GoTo Reference:="mTop"
End If

End Sub

 

[Norie]

Where in the code do you get the error?

 

[DDT~123]

Where in the code do you get the error?

When it reaches this line:
Windows(File1).Sheets(ws).Range("A10").Resize(.Rows.Count, .Columns.Count).Value = .Value

 

[Norie]

Which workbook are you trying to refer to there?

 

[offthelip]

I told you how to avoid using the clipboard for copy and paste in this thread that you started!! If you don't want my help I will stop helping you:
https://www.mrexcel.com/forum/excel-questions/1043479-vba-efficiency-copy-paste.html#post5008840

 

[DDT~123]

I told you how to avoid using the clipboard for copy and paste in this thread that you started!! If you don't want my help I will stop helping you:
https://www.mrexcel.com/forum/excel-questions/1043479-vba-efficiency-copy-paste.html#post5008840

I appreciate your help, but I tried the code you provided which didn't work. It kept pasting File2 values in all the tabs instead of File3, File4, etc.

 

[DDT~123]

Which workbook are you trying to refer to there?

File1 is the destination and File2 is the source.

 

[offthelip]

I appreciate your help, but I tried the code you provided which didn't work. It kept pasting File2 values in all the tabs instead of File3, File4, etc.

Just because it is copying to and from the wrong tabs doesn't mean you need to bin the whole idea, surely it just means correcting the source and destination for the copy and paste. As you cans see from Norie comment your requirement are not exactly crystal clear.
Also in the Forum Guidelines it quite clearly states:

1. If the answer you receive is inadequate for some reason, post a reply stating why the answer does not work and/or with more information (if needed) in the same thread.
2. If your question has not received any replies, do not start a new thread.