Copying data from a closed workbook to an open one

Greetings,

I'm trying to copy data from one workbook that populates via DDE. This is a subprocedure that is called to from another subprocedure that contains a timer to allow the data to populate. The workbook that has the DDE data has a static filename, but the target workbook that I want to paste the data in does not and changes with date every day. Because of this, I have not given variable names to the workbooks. I tried a number of different things such as a with statement and a couple of different ways to trick the new file into pasting the values. I'm getting a runtime error on my code PasteSpecial method of Range class failed. I'm unsure of what exactly is going on. It seems as though I'm not copying anything even though I've told it to do so in the code. Any assistance in getting it to paste the way I'm hoping for would be greatly appreciated.

Range("A:U").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy

Application.CutCopyMode = True
ActiveWorkbook.Close savechanges:=True

ThisWorkbook.Sheets("STATIC").Activate
Cells(1, 1).Select
Selection.PasteSpecial Paste:=xlValues
Application.CutCopyMode = False

Worked like a charm. Thanks AlphaFrog!