title: How do I reference to another (open or closed) workbook, and pull values back, in VBA? - Excel 2007
body: <p>Basically I need to gather a fair few figures from another workbook (Which is found and can be opened by a UserForm, therefore the location and names are variable). I need to use VBA for this as I also need to populate a chart with this data. I would prefer to not have to open the other workbook in order to do it, but if it is far easier then its OK.</p>
  <p>The UserForm is done and works fine, and I have the code I need to populate the chart, however I can't get VBA to pull back the data from the other workbook and assign it to the variables that I need it to.</p>
  <p>Any ideas on how I can get VBA to do this? It would be greatly appreciated.</p>