Excel 2003 - Access data from closed workbook
Posted on 2011-09-29
I am coding vba in File2.xls and wish to draw data from File1.xls!sheet1 without opening File1.xls. If File2.xls exists it will always be in the same folder as File1.xls.
The code needs to do the following
1: test for existence of File1.xls
If Not-Exist handle error and provide message to user
If Exist proceed
2: from File2.xls!Sheet1 get the data from Sheets1(A1).Current Region, store in an arrMyData, and provide message 'Data Collected'
3: close all links with File2.xls
Can someone please help with this?