Running EXCEL 2003.

I have an application that the user launches by opening a saved workspace
(.xlw). The saved workspace includes three related workbooks, all loaded from
fixed locations. A fourth workbook is needed, but its location is based on
the current date. I'd rather not rely on the user to figure out which
instance of the workbook to open. Can I run VB code that will figure out the
correct pathname and dynamically open the fourth workbook?

TIA,

Phil