|
楼主 |
发表于 2008-11-6 18:06
|
显示全部楼层
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
安装方法英文版:
To install the Solver Table Excel Add-in:
Be sure that the Solver is installed. If it is, it should appear under the Tools menu. If it is not, use the Excel or Microsoft Office installation CD to install it
Quit Excel if it is currently running.
Save the Solver Table.xla file to the exact same location as the Solver.xla file (see file info in box below).
a. On a PC, this will typically be at C:\program files\Microsoft Office\Office\Library\Solver\Solver.xla. (If it is not, use the Find command to find the Solver.xla file).
b. On a Macintosh this will typically be in the Microsoft Office:Office:Add-Ins folder. (If it is not, use Find File or Sherlock to locate the Solver.xla file.)
Launch Excel.
Under the Tools menu, choose the "Add-Ins" command.
Click the Solver Table checkbox to have Solver Table load with Excel every time it is loaded. (Uncheck the box to have Solver Table not load next time Excel is launched.) |
|