I need to obtain the path to a workbook when I open it and save it to
a named range "PathToForecastFile" in that workbook.

I have the code to obtain the filename of the current workbook:
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",
CELL("filename",A1))-FIND("[",CELL("filename",A1))-1)

I need to send out templates to clients and I cannot guarrantee they
will or can put it in a predefined path.

Thanks,
Dennis