Hi all!

I currently have two workbooks - one workbook, titled Interest Rates.xls,
contains a comprehensive listing of interest rates from various dates this
year. These dates are part of a range, titled InterestDates. The 2nd
workbook, pricing.xlt, is a template in which the user specifies what date
(s)he desires for pricing certain deals. Now here is the problem:

I need to create a list box, in the pricing.xlt template, which would
contain the dates available as specified by the range in Interest
Rates.xls - I understand that this can be done as long as both workbooks are
open. Is there anyway to program this in without having the source workbook
open? Can I refer to it using a network path? I know it can be loaded on
personal workbooks, but since we would have other users using this, is there
anyway to avoid this? Any programming tips would be extremely helpful.

Thanks in advance!