Hi Haas,
Try this,
In your pricing.xlt create one sheet that have a link with dates in
Interest Rates.xls. Once you set link, there is a no need to open
Interest Rates.xls every time. So you can use listbox or dropdown which
would picks up dates that is available from your new sheet in
pricing.xlt.
Regards,
Shah Shailesh
http://members.lycos.co.uk/shahweb/
*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!