Using a variable to represent the pathname in a formula
In , David Jones
spake thusly:
I need to refer to the master spreadsheet using a
variable. For example, if the master spreadsheet is located at
\\server\share\folder1\folder2, I need to be able to set this
location to a variable, call it location, and then in my "child"
spreadsheets be able to enter something like
='location\[spreadsheet.xls]Sheet1'!$A$1
Can't you just map the path to a drive letter in your operating
system (which seems to be Windows)? From the Windows Explorer with
the directory highlighted, click on the Tools menu and and select
"Map Network Drive".
-dman-
|