Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Arrays
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Arrays
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 |