Hi, I'm designing a userform with a drop down list. Based
on the value the user chooses, I need to get values out of
several cells in a closed workbook and populate them into
another workbook. How can this be done? I was told you
cannot get any information out of a closed workbook using
VB.