The solution to this is to use Excel's Concatenate functionality and cell references to get what you want. Quik Link only works with whole account numbers, so you have to 'create' the proper account-department for the =accpac formula.

For example, you have accounts 100044 and 100055 that exists for subsiduaries 44 and 55, respectively. What you have to do is enter into a cell the 2-character code representing the subsiduary (ie 44 or 55) and the cell must be formatted as text. In this example, say you put it into cell A5.

The formula (for link name gldata, field BAL and dept xxx) would be:
=accpac("gldata.BAL","1000"&A5&"-xxx")

When 44 is entered into cell A5, the value for account 100044-xxx is retrieved. If you enter 55 into cell A5, then recalculating the statement (function key F9) will retrieve the value for account 100055-xxx.

Doing it this way means that you can use the same Excel workbook for each subsiduary, assuming that each uses precisely the same 4-character accounts. Simply enter the 2 characters into A5 and recalculate. Note that you can also do the same thing for the department code, where '*' represents a consolidated statement, and the 3 character code is entered for a specific departmental statement. With the same example as above, with the department entered into cell A6, this would be:
=accpac("gldata.BAL","1000"&A5&"-"&A6)
Remember that A6 must also be formatted as text.

Hope this helps out.

[This message has been edited by Softrak Support (edited 11-20-2000).]