VBA for Excel treats path names differently for the Workbooks open and close
methods on the one hand and for use in cell formulae to a cell value to
another in a different workbook.
As long as the two workbooks have the same path, there is no problem, simply
use =[filename.xls]sheetname!celladdress. But should a path name be required,
what do I do?
Also in the workbook properties, path and file names are distinct paths,
both read only. How do I update the path property?