C
chief
I have linked cells from one workbook to another using this formula
which works great. The only problem is everytime I open the workboo
that has this link in it, a message pops up asking me to link the info
then when I click yes I have to choose the appropriate file in th
network. Is there a way to make it automatically choose yes for me an
then find the "SEPTEMBER04" file itself by using code or something?
='S:\[SEPTEMBER04.xls]INVENTORY'!A
which works great. The only problem is everytime I open the workboo
that has this link in it, a message pops up asking me to link the info
then when I click yes I have to choose the appropriate file in th
network. Is there a way to make it automatically choose yes for me an
then find the "SEPTEMBER04" file itself by using code or something?
='S:\[SEPTEMBER04.xls]INVENTORY'!A