I created a macro to move value-only information from another workbook, then created a command button and attached the code. The macro runs and works, but when the button is pressed I get an error 1004 Select method of range class failed. The debug stopped on the fourth line of the code:

Range("A15").Select
Windows("GWS Extractor (V8).xls").Activate
Sheets("Raw Data Transfer").Select
Range("A16:BW10015").Select
Selection.Copy
Windows("GWS Analyzer.xls").Activate
Sheets("Database Transfer").Select
Range("A16").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

Any clues to the problem? Both workbooks are open. The full code has multiple rehashes of the same basic code, pulling from different locations and placing in different locations.