zest1
03-20-2006, 03:55 PM
can someone please tell me the proper syntax to use a cell reference for part of a file path in another cell? I can't seem to get it to work.
A2 = proj1
I'd like this:
C:\projects\["A2"&.xls]
A2 = proj1
I'd like this:
C:\projects\["A2"&.xls]