I currently have a Macro that will copy data from another workbook into my
current workbook but I have to have the second one open for this to work. I
would like to change this so I do not have to manually open the second
workbook. I want to be able to press my shortcut key and have the second
workbook open, copy the data, paste it in my current workbook, and close the
second workbook. Here is the Macro that I currently have:

Windows("Blkacc223508.xls").Activate
Worksheets("Total-1").Select
Range("C3:N14").Select
Selection.Copy
Windows("2008 worksheets.xls").Activate
Range("B59").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=True
Range("A72").Select
End Sub

Thanks in advance for your help.