Does this give you what you want:
http://excel.tips.net/Pages/T002526_...Workbooks.html