Copy from one workbook to another

[dummies]

Hello friends help me with Macro to copy from one work book to another.
I have two workbook.
1. Students
2. Subject
. I wanted to copy row D from subject workbook to row D in students workbook.

What i have tried is:
Workbook("subject").sheets("detail").range("d2:d40").copy_
Workbook("students").sheets("detail").range("d2:d40")
But this is giving me slme error(script out of range)

Thank you

 

[Joe4]

Two things:

1. It is "Workbooks", not "Workbook".
2. You need the file extension in the file name, i.e.

Workbooks("subject.xlsm").Sheets("detail").Range("d2:d40").Copy _
Workbooks("students.xlsm").Sheets("detail").Range("d2:d40")

(be sure to change to the proper file extension to match your situation)

 

[dummies]

Two things:

1. It is "Workbooks", not "Workbook".
2. You need the file extension in the file name, i.e.

Workbooks("subject.xlsm").Sheets("detail").Range("d2:d40").Copy _
Workbooks("students.xlsm").Sheets("detail").Range("d2:d40")

(be sure to change to the proper file extension to match your situation)

Thank you very much joe4

<code>
Sub movefiles()
Dim myFile As String

With Application.FileDialog(msoFileDialogOpen)
.AllowMultiSelect = False
.Show

If myFile = False Then
MsgBox "No file selected.", vbExclamation, "Sorry!"
Exit Sub
Else
Workbooks("subject.xlsm").Sheets("details").Range("d2:d40").Value = Workbooks("students.xlsm").Sheets("details").Range("d2:d40")
End If

End With
End Sub
</code>

I tried in this way but i get runtime error 5.
Thank you.

 

[dummies]

Thank you very much joe4


I tried in this way but i get runtime error 5.
Thank you.

Sorry i mean to say what if i use filedialog instead of direct copy.

 

[Joe4]

I do not see any command to actuallyopen the file in your filr dialog script.
I am pretty sure that you need to actually open the file before you can copy and paste into it like that.