My boss wants me to separate a workbook into two separate workbooks an
link them. The prices are to be put in one workbook and the work area
and code are to go into another. Users will have a copy of code
workbook and will link to the price file over a network. I can liv
with the message about updating links, but what I would like to do i
put a variable in the cells that reference the pricing workbook so tha
I don't have to change the name of the linked workbook every month w
get new prices. Keeping the same name and location hardcoded in th
cells is not practical for testing and the monthly updates.

My question. Is there a way to substitute a variable inside the cel
for -'C:\Documents and Settings\My Documents\MyExcel\[Pricin
Sheets.xls]Sample'-

=(VLOOKUP(B8,'C:\Documents and Settings\My Documents\MyExcel\[Pricin
Sheets.xls]Sample'!$A$2:$F$4,2,TRUE)*B8)

As a bonus, how can I get rid of the message that comes up asking t
link to the unopen workbook

--
Bruce00
-----------------------------------------------------------------------
Bruce001's Profile: http://www.excelforum.com/member.php...fo&userid=2663
View this thread: http://www.excelforum.com/showthread.php?threadid=49082