hi there, does anyone knows the code to grab data from one workbook's
worksheet to another workbook's worksheet? i only know the code from
worksheet to worksheet. actually i got alot of files. so i have to grab
the values from diff workbook. i also only have the code to grab the
workbook.but it cannot paste the values into another workbook..
thanks for ur help!!!
=)

the code i'm using to grab the file:

'GrabWorkbook
Dim tstWkbk As Workbook
Set tstWkbk = Nothing
On Error Resume Next
Set tstWkbk = Workbooks("Book2.xls")
On Error GoTo 0
If tstWkbk Is Nothing Then
On Error Resume Next
Set tstWkbk = Workbooks.Open(Filename:="D:\Documents and
Settings\Administrator\Desktop\Book2.xls")
On Error GoTo 0
End If


--
raisin
------------------------------------------------------------------------
raisin's Profile: http://www.excelforum.com/member.php...o&userid=29141
View this thread: http://www.excelforum.com/showthread...hreadid=507158