vba access values from excel workbook from another excel workbook

Posted by user301752 on Stack Overflow See other posts from Stack Overflow or by user301752
Published on 2010-03-26T21:19:28Z Indexed on 2010/03/26 21:23 UTC
Read the original article Hit count: 686

Filed under:
|

Any ideas why this code will not work?

Workbooks.Open Filename:="C:\a.xls"
Workbooks("a.xls").Activate
Worksheets("b").Select
Dim OutputArray(10, 10)
OutputArray(1, 1) = Workbooks("c.xls").Worksheets("worksheet_otherthan_default").Select.Range(A1).Value

I'm trying to run a macro in one file (unnamed here) to get data from (a.xls).

© Stack Overflow or respective owner

Related posts about excel

Related posts about excel-vba