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.

The easiest is to open the workbook and grab the values, then close it.

Second easiest is to build a linking formula in a cell, grab the returned
value, clear the cell

Range("A1").Formula = "=C:\Myfolder[mybook.xls]Sheet1!B9"
vVal = Range("A1").Value
Range("A1").Clear


--
Regards,
Tom Ogilvy


"Shelley" wrote in message
...
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.

Hi Tom, do I actually code the "[" and "]"?
Thanks
-----Original Message-----
The easiest is to open the workbook and grab the values,
then close it.

Second easiest is to build a linking formula in a cell,
grab the returned
value, clear the cell

Range("A1").Formula = "=C:\Myfolder[mybook.xls]Sheet1!B9"
vVal = Range("A1").Value
Range("A1").Clear


--
Regards,
Tom Ogilvy


"Shelley" wrote in
message
...
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.


.