If you open workbook A, then create your formula that links to that workbook A,
you'll see how excel handles the path when you close workbook A.
And you update the path by saving the workbook to a different location. Same
kind of thing with the name--you have to save it with a different name.
Jai wrote:
>
> 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?
--
Dave Peterson
Bookmarks