Dim v as Variant
Dim bk as Workbook
set bk = Workbooks.Open("c:\test.xls")
v = bk.Worksheets(1).Range("A1").CurrentRegion
bk.Close Savechanges:=False

now v is a two dimensional array holding the values from sheet1 of
c:\test.xls

--
Regards,
Tom Ogilvy

"Dani" wrote in message
...

Is there a way to open up another excel file, and read in some values
and store them in an array to be used in a curren file???

Any help would be greatly appreciated


Dani


--
Dani
------------------------------------------------------------------------
Dani's Profile:
http://www.excelforum.com/member.php...o&userid=23542
View this thread: http://www.excelforum.com/showthread...hreadid=377096