workbook1 data to workbook2 data

R

raisin

hi there, does anyone knows the code to grab data from one workbook'
worksheet to another workbook's worksheet? i only know the code fro
worksheet to worksheet. actually i got alot of files. so i have to gra
the values from diff workbook. i also only have the code to grab th
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 an
Settings\Administrator\Desktop\Book2.xls")
On Error GoTo 0
End I
 
C

CLR

You can bring in data from other workbooks without using code if you
wish.......

='C:\[book1test.xls]Sheet1'!$A$1

This formula will bring in the value from the Workbook, Sheet, and Cell
specified......you can have one sheet bring in values from many other
workbooks/sheets/cells.........

hth
Vaya con Dios,
Chuck, CABGx3
 
Top