I have a macro that I am using to copy and paste information between
two workbooks. Since the original file is a txt file that I manually
convert to excel, I decided the best way to do this would be to save
the file, that way I coudl bounce back and forth between them. I have
2 other macros recored at the begining of my code but you can ignore
them. Please help.

Sub EnvelopeSR()
Application.Run "'sample report-do not throw-has instructions.xls'!
DeleteNonNumeric_ColB"
Application.Run "'sample report-do not throw-has instructions.xls'!
Delete_Rows"
ActiveWorkbook.SaveAs Filename:="Envelopes_SR.XLS"

Workbooks.Open Filename:="G:\Customer_Service\service reports\SR-
Template.xls"
Worksheets("Envelope Detail").Activate
Windows("Envelopes_SR.XLS").Activate
Range("A1:J15000").Copy
Windows("SR-Template.XLS").Activate
Range("A5").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
End Sub

The paste section fails every time.

Jay