Workbooks("Book1.xls").Worksheets("Sheet1").Range("A2")
Dim lngNo As Long ' 番号
lngNo = 1000
Dim objWbk As Workbook ' Book1
Set objWbk = Workbooks("Book1.xls")
Dim objWbk As Workbook ' Book1
Dim objSh1 As Worksheet ' Sheet1
Set objWbk = Workbooks("Book1.xls")
Set objSh1 = objWbk.Worksheets("Sheet1")
objSh1.Range("A2")
ThisWorkbook
ActiveWorkbook
With ThisWorkbook
.Worksheets("Sheet2").Range("A2").Value = .Worksheets("Sheet1").Range("A2").Value
End With
Dim objWbk As Workbook ' Book1
Dim objSh1 As Worksheet ' Sheet1
Dim objSh2 As Worksheet ' Sheet2
Set objWbk = ThisWorkbook
Set objSh1 = objWbk.Worksheets("Sheet1")
Set objSh2 = objWbk.Worksheets("Sheet2")
objSh2.Range("A2").Value = objSh1.Range("A2").Value