I would like to open a new xls file using the contents of 3 named ranges on
the current worksheet as the name of the new file.

The named range "mnf" "lot" and "exp"
ie (mnf=john, lot =gh , exp=09022006)

I would like to get the file name to be "mnf""lot""exp".xls
(ie johngh09022006.xls)

Any suggestions? Do i have to open a unnamed file then name it when i save it?

ty for any help

dr chuck