Copying from other Workbooks
 

I have written the following code.

Private Sub CommandButton1_Click()
If CheckBox1.Value = True Then
Range("C12:D17").Copy
Range("C18:D23").PasteSpecial
ElseIf CheckBox2.Value = True Then
Range("C12:D17") = "2"
End If

If CheckBox1.Value = True And CheckBox2.Value = True Then
Range("C12:D17") = "3"
End If



End Sub

How can I change it so the copied data is from another Workbook called
"VCCS" with a Worksheet called "Main Components"?

Thanks


--
SusieQ
------------------------------------------------------------------------
SusieQ's Profile: http://www.excelforum.com/member.php...o&userid=30818
View this thread: http://www.excelforum.com/showthread...hreadid=506314